The problem is what you are doing in your case statement... specifically your date math.

You are taking the value returned from the GetDate() function, and subtracting one year from it.

So,...

cheshirefox - thanks for posting this. This is very good information.

One point:

cheshirefox (11/23/2010)

---

Please notice the second bullet – this is what was causing our problem. The stored procedure created...

This should get you going. Just duplicate it for the other 26 columns.

Also, please check out the Cross-Tab/Pivot tables, Parts 1 and 2 links in my signature.

-- See how this...

Ahh Craig... you're always good for a chuckle! Thanks! 😀

Seth Kramer (11/22/2010)

---

Okay but where does the numbering at the end of the underscores correspond to the spid that created it?

Hypothetically, lets say I wanted to see what spid owned...

Try this:

in one query window, run:

CREATE TABLE #testvm (RowID INT IDENTITY);

In a different query window, run your command:

IF EXISTS...

Alvin Ramard (11/22/2010)

---

Jack Corbett (11/22/2010)

---

Thanks for all the well wishes folks. Still haven't seen the cardiologist, but have seen his nurse practioner, an internal medicine doc amd his...

Sounds like you need to use a LEFT JOIN to the table that might be null, and an additional join to the other field/table. Select using COALESCE(table.column.that.might.be.null, value.to.use.if.other.is.null) for the...

Yes, but I refer back to what Steve posted above:

If a device...

Really?

In SSMS, open up a job. In the Job Properties screen, select "Schedules"....

The spaces in this are going to complicate things greatly...

Grant & JP: I want to thank both of you for responding back. I hadn't been that interested before; now that I can see how it could be helpful, you'll...

ChrisM@home (11/22/2010)

---

@MonsterRocks - Sorry mate, got tied up, but Wayne jumped in with solution.

@Wayne - cheers mate,...

Lynn Pettis (11/22/2010)

---

Latest tweet this morning from Jack indicating that there was no heart problems, cholesterol is high so a change in diet. Also, he was fighting a headache.

So,...

Lutz - wouldn't the temp tables that I used handle that? Otherwise, you end up with 4 procs to handle...