My apologies, I misread that totally :blush:

Is this not a cross-post of:

http://www.sqlservercentral.com/Forums/Topic401899-8-1.aspx

??

Vladan,

I think that this is possible using the two temporary table method. However, would the two temporary tables joined on emp_no and unique ID not require that the users log...

Because of the performance degradation a cursor so happily supplies this could take anything up to 30 minutes to perform. At the moment, I can't see a set-based answer to...

Jonas,

Hi, if this is a one off you could use a cursor (:sick:) to run through each row in the table to transform it to the new structure. I'm guessing...

Can you provide the DDL (Create statments) for both of the tables? If you could also point out which columns from table A roughly equate to table B, we should...

Hi,

Is there a common column (foreign key) between the tables or is it just a list of dates? If it's just dates you can:

SELECT dateColumn FROM tableA WHERE dateColumn NOT IN (SELECT...

Hi, with reference to the BCP command:

The temporary table is a global temporary table (## prefix, not #). This type of table can be used between processes. To check the...

Sorry, I missed the Header spec.... All this experience and can't read!! Apologies...

Robert,

Using a DTS package you could have 4 steps that create the 4 different format requirements and write them to files. You could then use an ActiveX script and the FileSystemObject...

Hi Guys, let me jump in here...

How are the headers supposed to be presented in the first line? Are they to be Character separated (using a comma, space, anything)? If...

Adam,

DTSRun is pretty much what you're stuck with as far as I'm aware... I'd be inclined to investigate why the package was hanging. Things like:

1. What task is the package execution...

Just a quick one Steve, to say good luck and I hope all goes well tonight (and the rest of the week) for everyone from SSC....

Sadly, I couldn't talk my...

As always, formatting results is best left to the front-end application if possible. SQL Server is a RDBMS system for transactions and formatting options are limited.

However, for the second value...

I'd have to agree with Matt on this one. DTS has built-in workflows, so why not use them:

On Success - The next task executes when the previous task completes...