>
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.
Good stuff, KG. It is a boon to the UT that you not only have advanced SQL knowledge but that you are happy to share it. Have I said welcome back? ;-)