Sometimes the client application is less suetable for the formatting.

For example I sometimes do the formatting within SQL-server when serving for...

This is a rather old thread, so for this question it would have been better to start a new thread.

I use the numbers always as a rough indication;

Table Name ...

Use the following code to just see what is happening:

--------------------------------------------------------

-- Actual code to prepare for an UPDATE a Select

--------------------------------------------------------

;with

A as...

Sp_generate_Inserts, generates insert statements from an existing table. For example to create (part)...

--------------------------------------------------------

-- Actual code to UPDATE

--------------------------------------------------------

;with

A as (

select

...

For this type of problem I like the Windows functions to give each row a number which makes the row unique.

With CTE the 'double' rows can be removed.

...

Sorry additional,

I did write:

I am aware of the 'database task generate scripts'.

But I do not know how to do this with a scripted command.

(As with sp_generate_inserts, example:

sp_generate_inserts My_Table

)

sorry...

Thanks all,

Did try the suggested code, and indeed this was different than I expected. Thank you for educating me.

Thanks,

Ben

For my understanding:

1. Dirty reads is the reading of data which is not (yet)...

Thanks all for your responses:

Stop thinking about what you want to do to a print... think, instead, of what you want to do...

Jeff Moden (7/26/2013)

---

Using PRINT for troubleshooting can be a real PITA and the output sometimes doesn't show up until the end of the run instead of as the procedure run...

But this...

--------------------------- Wat I am looking for. (This does produce an error).

EXEC...

Thanks, we went ahead with this with no problems.

Thanks again for your input.

Ben

Maybe not the correct question.

If this is done online will this cause locks over a long duration ?

Or does it just handle just one...