Jeff Moden (9/22/2009)

---

Lynn Pettis (9/22/2009)

---

laughingskeptic (9/22/2009)

---

One usualy does not need a tally table larger than the largest table. In which case the following works as a generator:

declare @i bigint

set...

Here is some code to play with as well:

declare @Date1 datetime,

@Date2 datetime;

set @Date1 = '2009-09-22 12:20:21.333';

set @Date2 = '2009-09-22 12:20:21.000';

select

...

To get the best help in response to your request for help, read and follow the instructions in the first article i have referenced in my signature block regarding asking...

laughingskeptic (9/22/2009)

---

One usualy does not need a tally table larger than the largest table. In which case the following works as a generator:

declare @i bigint

set @i = 0

select @i=@i+1...

Jeff,

First, leave it to you squeeze another 33% out of a routine, awesome. I'll have to incorporate that change into my code. I think Steve needs to add...

Jeff Moden (9/22/2009)

---

Lynn Pettis (9/22/2009)

---

Jeff Moden (9/22/2009)

---

MrAkki (9/22/2009)

---

Nice article. 🙂

Another way would be:

DECLARE @Start BIGINT, @Step BIGINT, @max-2 BIGINT

SELECT @Start = 1, @Step = 10 , @max-2 =...

Jeff Moden (9/22/2009)

---

MrAkki (9/22/2009)

---

Nice article. 🙂

Another way would be:

DECLARE @Start BIGINT, @Step BIGINT, @max-2 BIGINT

SELECT @Start = 1, @Step = 10 , @max-2 = 10000000

SELECT...

Matt, Thank you for the link. I was not aware of this either and have been looking at it for a couple of projects that are currently on the...

MrAkki (9/22/2009)

---

Nice article. 🙂

Another way would be:

DECLARE @Start BIGINT, @Step BIGINT, @max-2 BIGINT

SELECT @Start = 1, @Step = 10 , @max-2 = 10000000

SELECT (Number *...

peter-757102 (9/22/2009)

---

I wonder why a SQL magazine published code that used a multiline table valued function given their reputation for scaling bad. It will not help to educate readers on...

dbishop (9/22/2009)

---

I am a bit perplexed by the article. I buiul a tally table in each of my databases a couple of years ago. Static table, 100K rows, PK. When...

Silverfox (9/22/2009)

---

I like the article but just a minor point, the code doesnt work, maybe it is the way it came across when formatted.

You are missing a space, in your...

SSC pays $25.00 for each published article. The last two articles I have had published here were done for free as I had originally published them on sswug.org, which...

siddartha pal (9/21/2009)

---

The first index was created when primary key was created on ID column. So it means, instead of creating a new index, I just need to modify the...

Roy Ernest (9/21/2009)

---

Do...