I ran the following select statement on the tally table created by the above script:

select * from tempdb.dbo.tally where n<=100000

And up to N=4354, the 'row number' is identical...

In case this is relevant, the tally table was created in tempdb as a permanent table (please comment if this is not a good thing to do), using the script...

:blush:

Well, it is a large one (if a little is good, big is better, no?)

Before I even get to the answer, let me try and explain away my ignorance. ...

Jeff:

Jan 3 2000 12:00AM is the beginning date

Sep 22 2009 12:00AM is the ending date.

d lewis

Additionally, cutting and pasting your last example into my ssms and running it as is

--===== Presets

DECLARE @DateStart DATETIME

DECLARE @DateEnd DATETIME

SELECT @DateStart = '2008-01-01 06:00',

...

It looks like your code as written fails if it encounters February 28 in a non leap year. (when I did the rbar approach using a cursor, I found the...

I finally dived in and started to try and understand how to use tally tables, and didn't take long to hit a wall. I tried the orders summary example...

Hooooot!

Leading commas all the way!

CAPS for all sql keywords!

Keep the aliases short and sweet!

😛

I'd never have guessed the discussion would be this long, but it's a good read on a...

For an IT type worker, I'm a bit of a luddite. I absolutely refuse to have a television, only got a cell phone last year, no ipod, and only...

Hate to be a spoiler, but the obvious solution to lowering energy costs is to reduce the footprint -- that is, heat and cool a smaller area. U.S. houses...

We live in the country, so most of our films are via netflix. However we do now and then see current releases. Of those mentioned, I think...

knausk (1/9/2009)

---

You do flaunt them at your own risk, certainly. And as you or someone here said, though I paraphrase, Americans are reluctant to be adults in so many ways....

I overlooked the 'overseas' part... Anyone who tried that in the U.S. would be run out of town (osha, etc.).

knausk (1/9/2009)

---

I knew a fellow at a large manufacturing company. His job was to wander around in any of their plants around the world and see what looked good and...

If you strip out the details of the HR person's comments -- that is, we all ought to strive to dress as Bill Gates, etc. -- the substance seems to...