>>
http://kevin_s_goff.typepad.com/kevin_s_goff_weblog/2013/10/10262013-transact-sql-tip-of-the-week.html>>
>>Going to start doing this on my blog - going to try to do one a week.
>>
>>The topic this week: passing tables as parameters to stored procedures
>>
>>Over the years, SQL database developers have used many different techniques for trying to pass a variable number of key values to a procedure.
>>
>>Options have included CSV strings, XML strings, temporary tables, and (yuck) cursors.
>>
>>All of them work (though cursors are the worst) - however, in SQL 2008, Microsoft added a new table type, so that developers could pass table variables (declared as table type templates) to stored procs.
>>
>>Hope people find it helpful.
>
>Just want to jump in here to say that it was your Bakers Dozen explanation of TVPs in Code Magazine that got me started using them. As I told you at the time it was so clearly explained I instantly could see their usefulness. Used them extensively at Dow Jones to handle some things that would otherwise have been terribly cumbersome.
>
>Anyone who isn't familiar with or comfortable using Table Valued Parameters in SQL 2008 should jump on everything Kevin has written on this (and also look for posts by sqlDenis and possibly Naomi N. on lessthandot) Once you start using them you will think of many ways to refactor stuff you've done before.
How can you combine Naomi and Kevin in the same sentence?