Ya the least we can say is that he has a colorfull style .

I really got to get that book...

and read it eventually .

Solution :

Select the distinct groups

cross join to the ref so you get all possible combinaisons

left join that to the calculated sum of your first partial solution

isnull() the missing columns...

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?