I often warn people that the article is not new or ground breaking, it's a memory aid. There are some SQL tasks that are hard for me to remember; this one is worse because I can't remember what it's called to look it up. <smiles>
At any rate, I'll post it here and put it on the SQL menu and when I need it again it'll be here.
The following example shows how to use SQL Table Value Constructors (SQL 2008 and above)
This allows you to insert a series of constants into a table. I use it a lot when building small lookup tables, I put it right after the 'Create Table' statement