#1CoolGuy (1/15/2009)

---

Thanks Seth for taking the time to help me out.

I was using Dynamic SQL because the tablename is built is built dynamically based on an input parameter. Sometimes...

dmc (1/15/2009)

---

True... it is slightly (very slightly) faster. And in billions of rows it could make a difference. But is it wroth compliance of standards and advantages of...

SHAPE and APPEND are not valid T-SQL key words. Here's an article on how to use them:

http://support.microsoft.com/kb/189657

If you use SELECT INTO with a temp table in dynamic sql, it won't be available to the proc that called it. Dynamic SQL launches in its own connection...

Transactions are definitely used in SQL 2000. I personally don't have much need for transactions so I don't have a ton of experience working them, but I'd assume you'd...

You shouldn't need the begin and end either or the line feeds either.

Try removing the your char(39)'s.

No problem Morris, glad we could help.

If the amounts sold were directly related to the amounts bought, this would be a good report. If your payroll does the same with hours worked and amount paid,...

These are kinda a pain to do in SQL 2000. With SQL 2005, they're cake. Here's one way of doing it in 2000. Please notice the way...

First of all, a disclaimer:

The report you asked for is something that is likely best handled in the front end. This really is not a cross tab report (at...

DECLARE @DOB datetime

SET @DOB = '1/20/1980'

SELECT CASE

WHEN DATEPART(DY,GETDATE()) >= DATEPART(DY,@DOB)

THEN DATEDIFF(YY,@DOB,GETDATE())

ELSE DATEDIFF(YY,@DOB,GETDATE())-1

END

Had to add to it, a small reward for not allowing myself to respond the other day when I first that post :hehe:.

I agree wholeheartedly Jeff. I mean, it's not like we're here to help educate people or want them to actually learn anything. I for one prefer to answer...

While many...