Or this which is a little different but could potentially run faster and you might want to test both a few times to see how they run.

SELECT

billable_transactions.siteid,

(CASE

WHEN Callid IS...

Look in you logs and event viewer, there should be a memory dump there. Please post as may be able to help understand what was going on at the time.

"Don't...

I agree as it that it would be usefull. What I really get frustraighted with is good articles with great names but they don't have any information that I need....

Well, I will be looking for it. And you'll love those trace flags, they give quite a bit of detail based on which ones you use.

"Don't roll your eyes at...

Thanks, interesting solutions is my forte.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I confer, don't do anything to that account unless you really are 100% sure you have a way back in. In my group there are 9 of us that have...

Use a cursor to do a join type loop into a temp table for your output, these is one of the most intesive things you can do. But other than...

It will not let you mix this way.

Try create procedure spInOutputTest

@InTest int

as

SELECT @InTest + 1

Then just do

EXEC spInOutputTest ?

this will work.

Sorry I could not find the reason.

"Don't roll your...

Also it would be nice to explain what trace flags you can turn on in SQL to catch those dead of night deadlocks that sometimes occurr. I have to say...

I always suggest going with the SP as there are numerous issue including security related fixes in them. To get a better idea of what the SP does, check out...

SELECT DISTINCT [name] FROM [paper]

Unless there is something I don't get here.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Actually I personally whave avoided the union the way you did as you techinically query the data twice and build two seperate outputs that are stacked together. Are a large...

When thinks like this occurr there is a stack dump to the Error Log, it will look something like this.

0x0047f904 Module(sqlservr+7f904) (CCvtTree::PdrgcidGetColumns+c)

0x006a7c97 Module(sqlservr+2a7c97) (CCvtTree::BuildGbAll+5d8)

0x006a64d7 Module(sqlservr+2a64d7) (CCvtTree::CorrelatedAgg+259)

0x00588bf7 Module(sqlservr+188bf7) (CCvtTree::PexprBuildFrom+3d6)

Find it and...

Glad to hear.

Don't roll your eyes at me. I will tape them in place.

I wasn't given an option, never saw any demos and was asked to build our own but it is no where near what you have requested here.

Don't roll your eyes...