You're right, only the 2nd part of this query fails on estimated query plan.

Declare @A table (name varchar(50) not null primary key)

Select * from @A

GO

Create table #a (name varchar(50) not...

You're right, I should have executed the original code, I'd have seen the error right away. Next time I'll try to ignore those messages :

SELECT A.Event_ID, A.Course_ID

FROM ...

Yup they're really getting you by not having you in the top 10 persones in that category .

Then I guess it's not too illegal >>

in the command prompt :

regsvr32.exe c:/winnt/system32/mscomctl.ocx

Then you should have this dll in the reference list and you "should" be able to access...

Here's one of my favorites, left by a few self proclaimed "programmers" : admire the abscence of nulls, the good use of naming convention and the correct choice of datatype...

As Noeld said and I confirmed, this should read like this :

/* Retrieve distinct Course count */

SELECT @CourseCount = COUNT(DISTINCT Course_ID) FROM #EventOpsList2

Anyone here would have spotted the error...

I wouldn't call that agressive... it's clear he doesn't know english very well and can't express himself as we can. What part did you find agrssive in there?

Do you have vb 6 installed or maybe .net?

Or an Mexican describe a hot day .

Wanna see something messy??

Widest table

HTH .

The column should be rtrimed automatically if you have a [n]varchar column. Are you sure that there are trailing spaces at the end . Or is it just...

Haaaaaaaaaa, there's your error.

May I suggest that you post the FAILING code next time so that we don't search for nothing.

Thanx Noeld for spotting that one.

I'm gonna restate this. This is the real performance gain you can get out of this.

I don't think you can reffer to normalization when talking about that thing. It could definitly be reworked a little bit (there seem to be a few flags missing...

Can you paste the original failing query here? Maybe I'll see something else.