http://kevin_s_goff.typepad.com/kevin_s_goff_weblog/2013/10/10262013-transact-sql-tip-of-the-week.htmlGoing 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.