Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Table design question

    How about something like this:

    DECLARE @data TABLE

    (

    EventIDINT,

    DataIdINT,

    DataVARCHAR(500)

    PRIMARY KEY (EventId,DataID)

    )

    INSERT INTO @data VALUES (1,1,'Ev1Data1')

    INSERT INTO @data VALUES (1,2,'Ev1Data2')

    INSERT INTO @data VALUES...

Viewing post 1 (of 1 total)