It might be in the SQL Server Logs.

Can you show us the "sp_ProfitStatEX" procedure code please?

You cannot just generate 6 result sets and expect the client to treat them all as one result set. You have...

Feliz Navidad!

Yeah, I always forget that T-SQL has the SIGN() function.

Kit Brandner (12/22/2008)

---

Try a 23-character long alphanumeric PIN code with certain characters excluded for legibility that can't be repeated in the database. So Jeff's solution wouldn't work. I suppose I...

I am not aware of anything that would be nearly as good as Views. TVF's if you have to (preferably inline), but Views wherever you can.

I can not recommend the first book (Wolter). It seems...

kathyoshea (12/22/2008)

---

My understanding (now) is that 2000 handled the order by in a function, but 2005/2008 does not, and that is by design - not just something I'm doing wrong....

Because which columns/indexes would be relevant changes all the time, the compiler cannot determine them ahead of time. If you split them into separate queries or even procedures, then...

Well then, Kudos!

I already did explain this:

Triggers and Service Broker activation procedures are different, because some kind of "activation" or "invocation" must occur, so there is no way for the T-SQL to...

Triggers have to handle multi-row changes, whereas stored procedures typically can only deal with a single row change at a time, so it can be clumsy (at best) to use...

Do you wantr to just turn a trace on & off, or do it need to receive the stream also?

If the first, then you can just issue the commands through...

Thanks for the feedback, Anirban. 🙂

There is no such function. However, you can emulate this with the following:

Select

Case When Sum(Cast(Col1 as int)) > 1 Then 1 Else 0 End