vociferous

I agree its a scope issue, but just out of curiousity, why is the procedure inserting into a table variable or #temp table at all?

All the procedure does...

It's an elegant weapon....

It didn't like the 5-part columns in the cte because the table you joined wasn't part of the CTE. It may help conceptually to think of the CTE...

I'm reasonably soft-spoken at most times.

Testing...

Testing...

Is this Thread on?

Jack "King" Kirby

(Nice pic of The Vision, by the way.)

'Nuff Said

frivolity

Antici....

(say it)

(say it)

(say it)

.... pation

So it is relevant here how? Respectfully, you should just let this go ... you're making a really poor impression. I've tried...

Do you consider it rows to be duplicates if ANY of the columns match, or only if ALL of those columns match?

Post up a few sample rows and what you...

One guess is that FFS = For F___'s Sake. Let's not speculate as to the missing f-word.

Posting answers for homework assignments does nothing to further the community, or...

I thought it was round by design. Without starting up the whole "football" debate again, it must be noted that there are other games where the...

vuvuzela'ed