I have a SQL routine that has been written by someone else. I want to copy the SQL file into an existing DB as a Store Procedure to run. It will create a list of new tables and reports to be used in the DB.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.