Glad you found your answer..

BTW , using an ID like this is quite bad practice. If it were me , i would have this as data on a...

Please keep to one thread per subject

http://www.sqlservercentral.com/Forums/Topic1184288-391-1.aspx

SqlServer has no bit-wise aggregations but something like this should do you fine

select UserID , Max(roleid&1)+

...

Jack Corbett (10/1/2011)

---

Hey guys I got some really cool news today. I was awarded MVP status!

I just hope I can honor that award the way that all the MVP's...

Hi ,

The query cost relative to batch is based upon the estimated cost, not the actual.

You mention UDF's, estimated cost of UDF's are 0.

That will be the difference.

Assuming , and i think from what you have said its a big assumption, that this is a sqlserver issue, use server side tracing ( never run profiler...

Grats Jeff , well deserved , thanks for all the help you've given me along the way...

So its recompiling as the temporary tables are defined 'out of scope'.

Instead of using a temp table you could try passing it as a TVP

What does the subtype column on the recompile event in Profiler say ?

calvo (9/6/2011)

---

There is no such thing as a "parameterized view" in SQL Server....

Please see this article

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

For how to help us to help you

2,100

http://msdn.microsoft.com/en-us/library/ms187926(v=SQL.90).aspx

But, if you need that worry you a proabably doing it wrong.

Just because.

It appears to be seeing it as a lower case 3.

Its probably documented *somewhere*.

select * from #x where c1= c2 COLLATE Latin1_General_CI_AI

select * from #x where c1= c2 COLLATE...

Are the temp tables causing the recompiles created in the CALLING stored proc ?

That will cause a recompile, you could pass the table a a TVF.

Its down to collation , try this

create table #x(c1 char,c2 char)

insert into #x values('³','3')

select * from #x where c1= c2

select * from #x where c1= c2

COLLATE Latin1_General_100_BIN