Regretfully, the business requirements don't allow me to denormalize. 

Anyways, that statement would only work if I could ensure that the text values were never the same length as a...

why that many temp tables?  can't you just

  set @stmt = 'select @value = cast(' + @colname + '  as varchar(4000)) from inserted'

  exec sp_executesql @stmt, '@value varchar(4000) OUTPUT', @value OUTPUT

 set...

Actually, the number of transactions we have is high, but this is the simplest solution considering the number of interfaces we have into our tables.  And, luckly the update statements...

We are in the mist of some drastic development changes.  I have over 1200 new columns comming in the next month or two and I have been told that there...

I thought about that and also about nested if statements.  The big problem is the number of columns in our tables and the fact that we change the columns quite...

So, there is no way in SQL server to get a record set and enumerate through the columns to get the column value without specifying the name?  I even tried...