tfifield (1/10/2012)
I would never have considered using actual columns from a table in a VALUES clause. Great little nugget there! I guess I need to think more outside the box.
In fairness, you can do the same thing with a bit of UNION ALL action, but I like it.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi