Code Samples from Code Camp 2009.2

As promised here are the links to the Sample code used in the Advanced Workflow Processes in T-SQL presentation from Code Camp 2009.2 held on Saturday October 17, 2009.

EXEC vs. sp_executesql & Temp Tables

DQSM – Data Quality Status Monitoring

The first zip file is the raw contents of the examples provided in previous journal posts for your convenience.

The second zip file contains the source code and sample files for demonstration.  Inside the main directory there are files with numbers leading the file name.  Execute these in order.  Some of them you just need to execute and move on.  The others you should spend some time in and look at the code and the output.  If you dig into the code, provided in the subdirectories, you will be able to explore the solution.

Most of the code can be used on any db.  Only the specific UDF and test Sprocs designed for AdventureWorks tables are not generic.  They serve as an example of what to do in you environment.

There are a few other little goodies in there to explore and play with but they are not critical to the presentation.

Update on Thursday, November 12, 2009 at 9:13AM by Joshua Lynn

The DQSM file has been updated.  There is now an example test that uses the @ParametersXML test parameter.

Also, there is a new simplified demo code illustrating the principles behind T-SQL Dynamic Workflows.

Simple Workflow Sample code {File}

Unzip the file and follow the files in numerical order. Read the comments to find out what's interesting about each file.
Source code as file