Over the past year, Linchpin People consultants have contributed to Pinal Dave’s popular SQL Authority site in the Notes From the Field series. Since I am new to Linchpin People, I just got in the rotation and contributed the 52nd installment. My post will teach you how to use Table Valued Constructors, a handy way to insert multiple rows into a table in one statement.
Aunt Kathi's SQL Server Home 