What other post? Post the URL so I don't have to look for it. 😉

On the homework, the method that Adam is leaning towards is not the method your...

Heh... in my shop, I tell people...

Answer the question, Sandy... what do you need this for? "Its one of the requirement" isn't an answer. It's homework, isn't it?

Actually, this looks like a standard "factorial" homework problem. What do you need this for?

midan1 (1/16/2008)

---

how to generate date backward from end to start

like this

begin

-- loop to insert date backward

while

@end_date>=@start_Date

begin

INSERT INTO @tb_temp

from middle of the month to end of the month

serial date

------------------------------

1 19/03/2008

2 18/03/2008

3...

Squirrel and S. Blvd...

We should get together sometime and do a couple of 12 oz. curls...

Nicely done, Dave...

PW (1/15/2008)

---

With SQL2K, the only way to avoid cursor (or 'hidden' cursor in a function) is to accept a non-dynamic query where the number of lines of text queried is...

Wayne West (1/15/2008)

---

I spent a good amount of time putting together my original post, it's too complicated a system not to include enough detail so that people can duplicate what...

Good luck with that... does TeraData use the same date functions as T-SQL?

Hey Kevin Boles! Here's your chance, buddy... show us what you've got! 😉

The error occurs because a variable can contain only one value... the unions return more than 1 value.

The option of using a table variable is good.

Ummm.... wanna tell us what your mistake was, please?

Why are you getting deadlock timeout errors? Because when a deadlock occurs, there's always a victim...

There really way to much to explain about deadlocks here... you really need to...

The folks that gave those types of answers didn't help?