Hmm, then that is strange, I can't see anything wrong with your Case statement, and in my own tests I can't reproduce the problem. Is it possible that the...

I'm not sure what you mean by 'not using the CASE'.

In your code the Case is run on every record. One of three things can happen:

If your carrier_id does...

Thanks for all the ideas! I ended up going with the cross apply in this case, and it works great.

How about just using the keyword Not?

As in,

WHEN NOT P21PLAY.dbo.p21_view_oe_pick_ticket.carrier_id IN

The only thing I could add is that maybe you could put the 'EXECUTE dbo.sp_Procedure' line inside the function, and then using the function in your select statement. Not...