Tag: sql-server-2012

I have a big table with some columns having lookup values. I want to create a description column for each lookup column and populate them with description from lookup table. Here is one example main table select id1, id2, id3 from idtable; id1 id2 id3 1 2 3 1 3 4 look up table select …

Case statements with Join on lookupRead More