I have a sql 2008 R2 problem that I’ve tried to accomplishing using dynamic sql but, no luck yet.
Code:
Create Table Events ( PKID int Not Null, TimeStamp Datetime, EventID int, Eventdata int) Create Table Eventdatalookup( Event int, DataLookupTableName varchar(100)) Create Table TypicalEventDesc1( EventData int EventDataDesc varchar(100)