bcp doesn't include column headers (unless there's an option I don't know about). For this output I need column headers and columnar data...similar to a text output from query...

I figured out three things: 1-it was taking a long time because there was so much data. 2-it works faster when using a "real" table instead of the ##temp...

I just disovered that if I dump the contents of my ##temp table into a real table the osql command still hangs when run from the stored procedure, but the...

Still useful 2-years later! A couple of notes. If used in a longer queary the statement before WITH needs to end with a semi-colon (;). and the...