OK, this procedure and it's nested cousin caused issues again this morning. Here is the odd part, the proc. running through Crystal Reports ran just fine. I open...

Very good! Thank you.

It surprises me that the DELETE statement works because I would have thought that the table would have to be explicitly named, but it works nevertheless.

OK, now I wish that I could borrow the head-desk avatar from WayneS! :angry:

After getting fed up with verifying the parameters and parameter values over and over. I...

Ha! Don't feel like the Lone Stranger on that one - I have...

Thank you Garadin, I actually changed the name of the calling procedure's temp table and am still getting the error. So I must have been wrong about that -...

Yes, but it seems to be on life support this morning.

I hope I was wrong, I...

Paul Randal had this intriguing link on one of his tweets today (that he got from someone else).

The Org Charts Of All The Major Tech Companies (Humor)

That doesn't look like SQL - because of the "IIF" included.

But I think you're only specifying the year and not a range. So in effect you're telling the program...

You mentioned 3COM, that company used to be one "my" clients (of a company I used to work for)! I even got a tour once at their Palm plant.

I...

Ninja's_RGR'us (6/28/2011)

---

Here's a sample concat code. Enjoy the little tweaks!

SELECT

T.name,

STUFF((

SELECT

...

Please show the code that you used, it would be much easier.

Edit> didn't see that code at first. Never mind.

Ok, blocked. I didn't know you could block a follower.

Craig Farrell (6/27/2011)

---

mtillman-921105 (6/27/2011)

---

I've never tweeted, but I already have a follower somehow! Here's one of their delightful insights:

So my nose ring hole got reallly small cause i've been...

I've never tweeted, but I already have a follower somehow! Here's one of their delightful insights:

So my nose ring hole got reallly small cause i've been having a really...

Craig Farrell (6/27/2011)

---

Oh lord no. The thread will...