And, yeah... you could call it "Numbers"... but I'm one of those old guys where the table name shouldn't be a plural... :hehe:

Or "number" or "sequence" or... that's all part of the reason why I...

Heh... no problems there, Ryan... it'll generate a million rows very quickly for performance testing, as well.

Although the last problem is correct, I can tell you that whoever wrote the test is probably looking for the outer join solution instead of the where not exists solution....

You've already got one... Books Online 🙂

First, you might want to try asking your Oracle question on an Oracle forum... you'll usually get more correct answers that way... just a thought. 😉

Second, Oracle requires you to...

Here's a demo of what you can do in cases like this in both SQL Server 2000 and 2005... test data included...

--drop table jbmtest

--===== Create and populate a 1000 row...

Having one of those "where's my porkchops and slingshot" days, Grant? 😀

Personally, I don't allow developers to have write access to anything in production... violates all sorts of merchant agreements and PCI standards not to mention a total lack of...

Thanks, Barry... I've never heard of anyone else calling such aggregations a "Tally Table", but I certainly can see where the term both applies and is convenient.

Just to throw another...

You don't actually need a numbered column using the TOP (XX) methods... just need a good set of indexes and the correct "sort".

Ok... thanks... just trying to figure it all out... I think that's the last piece. I'll see what I can do tonight.

Heh... I've done the exact same thing... start thinking "Quarters", start writing "4's" 😀

rbarryyoung (4/30/2008)

That's probabrly why, Jeff. I did some work for an insurance company several years ago...

I'm curious... Why 4 months? That's a third of a year...