I found that char(13) is going to create a break line.

Any other formatting options?

Your solution is the perfect one.

Thanks a lot Remi Gregoire!

yes, just I forgot to mention something that is changing the results.

in the comment table I have an userid and I want to show for the specific users, the sum...

Thx to PBirch, too.

Sorry I did't see your response only after I posted mine.

Thx mharr. So, now I can go ahead with all the software installation for the new PC. I just wanted to make sure, that I will not spend 10 hours...

I think you guys are right. I will run the DTS every month with append option on. Since every second are at least 10 records added, how can I make...

The data file is 750 M. The log file is 4 M.

The transaction file growth is 1500 M. (I tried with 500 M in the beginning, it didn't worked).

There...

I checked the log on AS400, and it was recording the job sign on, but nothing else. In other words no error message on the AS400 side.

Durug

Another question related to my problem: when an updated is issued (for just one field - the table has 5) the inserted logical table will contain all fields or only...

I found the problem

Set XACT_ABORT ON

Here is were I found the solution and for more explantions:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q306649&

Thanks a lot,

You are great.

I had to use the condition isnull(...)

Durug

Thank's a lot!

Thanks a lot!

I was close to your solution but I was missing the alias t for the union select statement.

And I was out of solutions.

Really appreciate.

Durug

BillSQL: it works if I eliminate the variable from the @strSQL

Paul: this is the solution that I used before, but I was trying to avoid the temp tables.

Thanks a...

Thanks. I'm not getting any error, but now after executing the SQL statement

and trying to print the @comp_failed I have no value in it.

Is it becasue the conversion, or what???...