Hello
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)
...