Thanks Eric.

Much of these are against a db built specifically for reporting. Will check on cardinality.

Thanks again.

Old topic but still relavent...

In my previous job, I always used CTEs and they were much faster when compared to temp tables.

In the current place, strangely enough Temp tables almost...

@Qutip

I also face the same issue with GUIDs.

Use Jeff's Splitter. It is awesome.

I converted the GUID column to varchar and it worked. Try it out

cast(<GUIDColumn> as varchar(max)) IN (SELECT...