James Stover (7/26/2010)

---

OK, this is going to come across really crude but....surely some of the best "thinking time" has to be sitting on the toilet. When else do you get...

With "Order by" it does not need to be something in your select list.

So you can select datename(month,YOURFIELD) and order by datepart(month,YOURFIELD)

You only specified one of your two tables in the join. What is the structure of the table that has monthly data in it? Does every record in...

Eugene Elutin (7/26/2010)

---

Nevyn (7/26/2010)

---

The way "money" and thus "isnumeric" handles commas seems to be fairly dumb, though. Instead of validating commas in only certain placements, I guess they decided...

The way "money" and thus "isnumeric" handles commas seems to be fairly dumb, though. Instead of validating commas in only certain placements, I guess they decided to just make...

Sorry, I just found that comment by you funny considering you were asking people to spend their time to help with your problem, and doing what he asked would have...

Lynn Pettis (7/23/2010)

---

It would help if you could provide the DDL (CREATE TABLE) statement(s) for the table(s) involved. Can't really help based on what you have posted.

Did you try...

ss_nl (7/15/2010)

---

By using the query below I'm getting 3 kinds of productStatus results:

"Upgrade_Year", "NULL" or "Upgrade_Basic".

Why always NULL in stead of "Upgrade_3Months" ??

This should be the logic:

----

If the latest ActualDate...

A lot has been covered already, but I'll just add 2 quick notes: "sp_" as a name is a bad idea (system will look in master db), and as...

Solution above. I was editing while you were posting.

First and foremost, I'd say that doing this is probably a bad idea. Im not sure if you're talking about updating the table (a really bad idea), or just...

Actually, you can blame me for the isnulls and the full outer joins. I am appropriately humbled. Hadn't heard of coalesce before, Im embarassed to say, and the...

Just a heads up on this one to watch out for SQL injection vulnerabilities here. Just parsing a querystring in a stored procedure and using it to dynamically build...

Are you connecting it to a reporting tool? Crystal or SSRS would probably do this easier than straight SQL, while providing nicer formatting.

Heck, even just doing a raw query...

Could you post the script you have so far and the table definition? This one is a tad more complicated, and just easier to show using the actual parameters and...