Say it ain't so, Bruce !!! :w00t:

I can't code tonight but my brain is still functioning and I have an idea. Why not use a tally table...

By the way, my error and my apology for mentioning row_number(). This has gone on for so long, that I forgot which forum(s) we were in. ...

Fox, I promise you, I would much rather we all got out of the insult mode, and got into constructive problem solving. It's really a...

Just saw your repost with the corrected SQL, fox. He started with your code, and you had that commented out. Garbage in, garbage out, remember?

I'm...

That WAS quick, Jeff.

Fox, here is the deal. An INSERT INTO can come just before a SELECT Statement, and everything in the result statement feeds into the INSERT....

This will have to wait until tomorrow because we're having guests over tonight to watch "The Quiet Man." Someone else may beat me to it. ...

Got it. I think we are waiting on another post from G at this point.

No problem. That question gets asked a lot when it seems as if the functionality should be implemented outside SQL server. What's the name of...

Speak not lightly of Old Father Eternity.

Azeem, may I ask why you want it in columns like that? This is just out of curiousity about your business requirements. Sometimes there is...

An excellent article on the numbers or "tally" table can be found here [/url]. It's just a list of numbers from 1 to whatever. ...

Good one. I need more Happy Joins in my life.

I've got a couple of good friends who are, or were, referees, Bruce. They both felt it was a great way to be "in" the game, as...

Most definitely, Steve !!

Being the all-American Dutch-Scots-Irish-German-with-a-touch-of-snapping-turtle boy that I am, I am wearing the green and would proudly quaff a green beer with you in about two hours. ...

The Thread is rather like the free-association of our collective consciousness. Or the nascent Skynet... whatever. You can get lost easily if you don't get...