This was bugging me so I did some searching. 

Here's more than you ever wanted to know about the shortcomings of ISNUMERIC:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=243646&p=1

(with a link on the first page to...

ISNUMERIC will fail due to the fact that there are things other than 0-9 that are valid for the function since it also checks for float, decimal and money types. Someone...

Have a look here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=489146&SiteID=1

What you're looking to do is a PIVOT.  If you've got 2005 it's fairly simple.  If not, search this forum and you'll find several examples.

I just found this on the MSDN forums:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=249401&SiteID=1

It's 2005 but there may be something useful for you

Add: Where TableB.salesrep_code is NULL to the LEFT OUTER JOIN statement

You should also investigate foreign keys so that you don't have to continue doing this.

This has never been an issue for me - even when I work for young startups.  But then, I go in expecting occasional long nights and weekends and demand the...

Just saw the latest update on the red paper clip barter.  He got his house:

http://www.cnn.com/2006/TECH/internet/07/10/paper.clip.to.house.ap/index.html

Not having done any testing, I suspect the reason why is the same as what is discussed here:

http://sqlservercode.blogspot.com/2006/06/delete-and-subquery-in-problem.html

There are many ways to tackle this beast.  Default values are an option, using a sql stored proc (as part of the DTS or afterwards) is an option, using a...

That's a nonsense answer from the developer.  He's just being lazy.  Even if the code is "embedded" he can provide examples.  (I'm speaking as a former software developer turned DB...

Agreed, Farrell.  I forget about using MAX on non-numeric data...

That color coding was mine to highlight the issue.  In SSMS it doesn't break.

That sounds more like an issue with whatever is calling the stored procedure, not the procedure itself.

It was more like Sergiy's example. 

Although it's interesting that Kenneth mentioned the GO command, as that is what the compiler was having issues with.  (Except they well were outside...