WOW... and I thaught I was starting to know something about t-sql.

Where did you learn to do that?? (I know it's just a little trick but still it's not that...

You don't need dynamic sql to do this task, please stay away from it.

Are you susbscribed to the mailing list or to forums?

But it is a nice way to create a few version of the same proc and see which one performs the best.

Why not truncate / reinsert??

Might save you the permission problem in this case.

Create proc MyProc @Operator as varchar(2), @EquipmentCount as INT,

AS

Set nocount on

select count (*) as carrier_count from dbo.v_MTSTM_EquipmentCountByCarrier where 0 <

case when @Operator = '<' and equipment_count ' and equipment_count...

Maybe we should find a way to scare these guys away .

And from my belly profile you could see that you'd have plenty of room to bounce things off me .

I for one just ain't afraid of that tiny shark... he's gonna have to try harder to scare me off this board .

Glad you can work it out...

Is it possible that you forgot 1 column in the exists?..

or that the diff ljoin screwed up more data than you thaught?

Seems ok from here... what's the problem??

Did you do a select into of the full statements or only the last join that was causing problems?

Hence my suggestion to read the whole post before trying to help... It's happening far too often these days (not just you ).

not in on 8 M records?????????????????????????

I would strongly suggest left join or not exists on this situation.

As it's been suggested you can run a left join or a not exists statement to see which line is missing from the second table. As far as syntaxe...