http://code.msdn.microsoft.com/SQLSequence/Project/ProjectRss.aspxThis TVF generates a contiguous sequence of integers. Useful for generating test data, populating calendars, etc.http://code.msdn.microsoft.com/SQLSequence/Release/ProjectReleases.aspx?ReleaseId=400Use it like this<br /><br />select Seq.Value<br />from Utils.Sequence&#40;1,1000&#41; seq<br /><br />or <br /><br />select dateadd&#40;d,Seq.Value,&#39;2000-01-01&#39;&#41; d<br />from Utils.Sequence&#40;1,2000&#41; seq<br /><br />to generate a calendar.<br /><br />DavidWed, 25 Feb 2009 20:26:38 GMTUPDATED RELEASE: SqlSequence.sql (Feb 17, 2008) 20090225Phttp://code.msdn.microsoft.com/SQLSequence/Wiki/View.aspx?title=Home&version=6<div class="wikidoc"> <b>Resource Page Description</b><br />This TVF generates a contiguous sequence of integers. Useful for generating test data, populating calendars, etc. <br /> <br />This is a Table-Valued User Defined Function to generate all the integers between two endpoints. It's surprisingly fast, easilly beating my best effors at writing a CLR UDF to do this.<br /> <br />Use it like this<br /> <br />select Seq.Value<br />from Utils.Sequence(1,1000) seq<br /> <br />or <br /> <br />select dateadd(d,Seq.Value,'2000-01-01') d<br />from Utils.Sequence(1,2000) seq<br /> <br />to generate a calendar.<br /> <br /> <br />NB: this is not a replacement for IDENTITY columns or a oracle sequence work-alike.<br /> <br />NB2: This query uses a stack of Common Table Expressions to generate the numbers, and the original implementation is credit to MVP's Steve Kass and Itzik Ben-Gan.<br /> <br />David<br /> </div>dbrowneWed, 30 Apr 2008 22:25:28 GMTUPDATED WIKI: Home 20080430Phttp://code.msdn.microsoft.com/SQLSequence/Wiki/View.aspx?title=Home&version=5<div class="wikidoc"> <b>Resource Page Description</b><br />This TVF generates a contiguous sequence of integers. Useful for generating test data, populating calendars, etc. <br /> <br />This is a Table-Valued User Defined Function to generate all the integers between two endpoints. It's surprisingly fast, easilly beating my best effors at writing a CLR UDF to do this.<br /> <br />Use it like this<br /> <br />select Seq.Value<br />from Utils.Sequence(1,1000) seq<br /> <br />or <br /> <br />select dateadd(d,Seq.Value,'2000-01-01') d<br />from Utils.Sequence(1,2000) seq<br /> <br />to generate a calendar.<br /> <br /> <br />NB: this is not a replacement for IDENTITY columns or a oracle sequence work-alike.<br /> <br />NB2: This query uses a stack of Common Table Expressions to generate the numbers, and the original implementation is credit to MVP's Credit to Steve Kass and Itzik Ben-Gan.<br /> <br />David<br /> </div>dbrowneWed, 30 Apr 2008 22:25:00 GMTUPDATED WIKI: Home 20080430Phttp://code.msdn.microsoft.com/SQLSequence/Wiki/View.aspx?title=Home&version=4<div class="wikidoc"> <b>Resource Page Description</b><br />This TVF generates a contiguous sequence of integers. Useful for generating test data, populating calendars, etc. <br /> <br />This is a Table-Valued User Defined Function to generate all the integers between two endpoints. It's surprisingly fast, easilly beating my best effors at writing a CLR UDF to do this.<br /> <br />Use it like this<br /> <br />select Seq.Value<br />from Utils.Sequence(1,1000) seq<br /> <br />or <br /> <br />select dateadd(d,Seq.Value,'2000-01-01') d<br />from Utils.Sequence(1,2000) seq<br /> <br />to generate a calendar.<br /> <br /> <br />NB: this is not a replacement for IDENTITY columns or a oracle sequence work-alike.<br /> <br />David<br /> </div>dbrowneMon, 18 Feb 2008 19:40:29 GMTUPDATED WIKI: Home 20080218Phttp://code.msdn.microsoft.com/SQLSequence/Wiki/View.aspx?title=Home&version=3<div class="wikidoc"> <b>Resource Page Description</b><br />This TVF generates a contiguous sequence of integers. Useful for generating test data, populating calendars, etc. <br /> <br />This is a Table-Valued User Defined Function to generate all the integers between two endpoints. It's surprisingly fast, easilly beating my best effors at writing a CLR UDF to do this.<br /> <br />Use it like this<br /> <br />select Seq.Value<br />from Utils.Sequence(1,1000) seq<br /> <br />or <br /> <br />select dateadd(d,Seq.Value,'2000-01-01') d<br />from Utils.Sequence(1,2000) seq<br /> <br />to generate a calendar.<br /> <br />David<br /> </div>dbrowneMon, 18 Feb 2008 18:43:36 GMTUPDATED WIKI: Home 20080218Phttp://code.msdn.microsoft.com/SQLSequence/Wiki/View.aspx?title=Home&version=2<div class="wikidoc"> <b>Resource Page Description</b><br />This TVF generates a contiguous sequence of integers. Useful for generating test data, populating calendars, etc. <br /> <br />This is a Table-Valued User Defined Function to generate all the integers between two endpoints. It's surprisingly fast, easilly beating my best effors at writing a CLR UDF to do this.<br /> </div>dbrowneMon, 18 Feb 2008 06:18:12 GMTUPDATED WIKI: Home 20080218Ahttp://code.msdn.microsoft.com/SQLSequence/Release/ProjectReleases.aspx?ReleaseId=400Use it like this<br /><br />select Seq.Value<br />from Utils.Sequence&#40;1,1000&#41; seq<br /><br />or <br /><br />select dateadd&#40;d,Seq.Value,&#39;2000-01-01&#39;&#41; d<br />from Utils.Sequence&#40;1,2000&#41; seq<br /><br />to generate a calendar.<br /><br />DavidMon, 18 Feb 2008 03:52:41 GMTCREATED RELEASE: SqlSequence.sql (Feb 17, 2008) 20080218A