Stored procedure XML This screenshot lists the source of a SQL Server 2014 stored procedure hitting the AdventureWorks2012 database, selecting data from the Customer and SalesOrderHeader tables.

Often times, I work with a stored procedure that takes a complex input and does some work with it. By complex, I usually mean at least one value passed in that contains a non-specific number of ...