So, speaking of formatting tools, I just got a complaint because I formatted the code from the stored procedure that I worked on and that generated too many...

Instead of a # temp table, write the data to a permanent table and then drop the table after the BCP export.

Also, stop putting a semicolon before the WITH when...

You really should post your solution. It may help others with a similar problem.

I am sure it can, unfortunately it has been over nine years since I did anything with SSIS so my knowledge is not what it used to be.  One of...

I have been doing this for over 30 years. I found that people who post bad SQL on forums also write bad code in production. As one guy told...

Joe,

In addition to what Thom said, the OP also stated that he is stuck with what he has at this time.  Sometimes you don't have the option to fix things...

When I came back from Afghanistan four years ago I found myself winding down my officiating soccer.  Partly because I coached a U18 girls competitive team in the Fall of...

You are comparing apples to oranges.  The ORDER BYs aren't the same.  If you can't recreate the issue it tells me that it has something to do with the actual...

I have to agree, need to see the code, DDL, and some sample data that recreates the issue.

Change this, FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)'),1,1,'' ), to use NVARCHAR(MAX) in place of the VARCHAR(MAX).  The implicit change is causing you to lose the UNICODE values.

I was getting ready to review Service Broker as I am looking at using it is a small project, so well timed question.  I was able to answer it without...

Sounds like a change that happened at a previous employer after I left.  We had setup numerous SSIS packages using dynamic configurations so we could develop and deploy them to...

Just wait until the company has a WTF moment and you know what hits the fan.

Also, could you post a small sample set of data being passed into the stored procedure that is at least representative of the data actually passed in to the stored...

Would you please post the DDL for the user defined table?