Still happens that someone posts in the wrong forum. They deserve an answer too .

is the #temp table allowed as a parameter?

Can you elaborate on this one AJ?

3. Examine the joins, where statements, etc.. Something as simple as FieldX 'D' can dramatically cause your system to tank (especially...

If you need to share data between procs, you'll have to use a temp table.

Otherwise test both versions (variable, perm) and see which is faster in that situation.

I was wondering if it was possible to see the values of the input parameters of the RPC in the trace.

I've seen this on my system... Hard too believe but sometimes the users require that (however strange that may be).

Never thaught of that one .

and DateContract < dateadd(D, 1, datediff(D, 0, GetDate()))

Also keep in mind that my version will allow for an seek to be made on any avalaible index for that column,...

Actually, he'l have to remove all the As DataType, use createobject instead of set and change the enumeration constants to their actual values. It's not hard to do, it's...

Yes, but I like to see it so I remember what happens if the case is false. But that's just me.

Just on a last note : bigint takes 8 bytes and handles numbers from -9 223 372 036 854 775 807 to 9 223 372 036 854 775 807. Decimal(10,?)...

Just to elaborate on David's answer. Exists returns true or false. As soon as the query would starts to return data, the exists exit.

I didn't say I wans't ok with it .

You have to put the jpeg on a web server, or we won't be able to see it.

BTW his name is Joe Celko, enthusiast is just related to his number of posts.

Just wanna add that the the longer the string in the charindex function, the slower this...