Thanks Scott,

I had to come up with a temporary work around while I worked on the problem of this Stored proc, I will incorporate some of your suggestions in...

Jay_Noob (9/5/2008)

---

jomills,

I'm fairly new to the database game, so excuse my question if it is obvious. Why are you joining to ord_deal as a sub query instead of joining...

Sorry, I should have stated the server before hand. The server is still SQL2000 SP4, I know it's out of date, and it will be upgraded in the coming...

Thanks parackson, I will give the COALESCE a try in the query. Unfortunately I wasn't around when this script was produced for the report so I can't attest to...

Thanks for the reply, Lynn.

That part I get. I guess what I find odd the second part of the statement doesn't evaluate the equality of a column but of...

This link should help as well:

http://technet.microsoft.com/en-us/library/ms143799.aspx

It gives a list of things you need to consider or at least be aware of.

Nick Beagley (6/22/2008)

---

i was sure i chose the 2nd one and was suprised when i got it wrong. But it said the correct answer was the one i thought i...