|The Message text:
This email was created by [your name] who thought you would be interested in the following Article:
"Using Common Table Expressions and Recursion in SQL Server 2008"
By using recursion (and CROSS JOINS), you can generate data without looping or hard-coding INSERT statements into a temporary table.In the example below, you can use recursion to generate a week of scheduling data for three employees. -- Count variable, set to 7 for a week's worth of...
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!