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...

Hence the best practice of having everything owned by dbo (or at least the same user).

Thanx for pointing that out Chris.

I'd go farther in that statement, make a function that returns the computed column. So you can reuse the logic somewhere else.

But if you want more help, I defenitly suggest...

How long would it take to modify the application?

Also why r u using decimal(10,0)?

Can't you use a bigint, or int instead? It would propabely solve the problem and also allow...