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 (2,1,'Ev2Data1')

INSERT INTO @data VALUES (2,2,'Ev2Data2')

INSERT INTO @data VALUES...