Thanx, how about the input parameters??

Sorry to keep asking questions. My thaughts process is a little slow atm (starting to imagine how many new ways to solve problems this...

Oops, I taught for a sec that Suri was one of your nicknames. I may have missed something after all .

I hope Joe's not gonna read this... we're not gonna hear the end of it.

Another option would be to have another look up table on which you could join to, and then sort on a field of this table (which would be ordered in...

Not a bad thing... I've read of many bugs with this syntax on this very board. It was time for it to go

I just have a little more time for this ATM.

Don't forget that the more I post, the more I learn. On many cases here I have to search 10-15 minutes...

Do you mean that you want to have a line for each priority even if no calls were taken with the priority?

Can you show us some sample data from the 2 tables?

I'm not 100% sure it's possible with you current design.

Is this behavior changed in Yukon?

maybe this would work (never done this) :

Create a temp table (cannot be a table variable)

Then do this :

Insert into #temp (col1, col2) exec @hr = sp_OAGetProperty @oUsers ...

Hehe, did you have time to hit the record button??

Maybe you could play it back here .

It depends on the size of the table (and the memory avalaible). If the table is very small then it's gonna be in memory only, but at some point,...

Don't know all the exceptions, but as far as I know you must always specify the owner when referencing a function (and is a best practice to always do it)...