Jeff Moden, why we do not question the fact that in production environment

we have garbage - garbage database design, garbage data, garbage applications that produce garbage results.

Before that garbage...

jon-688305, thank you very much for you input. I am sorry if I did not stressed enough that the data

in the tables is not correct/valid for multiple rows and...

Hi Alan,

now the new, inproved version of the proc with

identity property is available from the same link. Format 1, type 1.

Thanks

Regards

Yakov

Dear WildGoose,

please read this article again.

Run an example or two.

The point is you do not need to do copy and paste. Query Analyzer does it for you for free...

This...

Dear Sam C.

if you do a search will find ten thousand articles on "Keyboard Shortcuts in SQL Query Analyzer". Ten thousand the same articles!

There is no second article or book that...

Dear Vince Formica,

please read this article again.

Run an example or two.

This technique was tested multiple times in different shops and it really works. It does work!!!

You will enjoy its...

Dear Sam C,

please read this article again.

Run an example or two.

This technique was tested multiple times in different shops and it really works. It does work!!!

You will enjoy its...

Dear Mark Hickin,

please read this article again.

Run an example or two.

This technique was tested multiple times in different shops and it really works. It does work!!!

You will enjoy its...

Dear Alexander Yuryshev,

As of today(five yeas later), there is no book or article that describes this simple task and people continue the old not efficient "copy and paste" method... Thousand developers...

Dear Lancea,

please read this article again.

Run an example or two.

This technique was tested multiple times in different shops and it really works. It does work!!!

You will enjoy its simplicity,...

Dear Graham,

please read this article again.

Run an example or two.

The point is you do not need to do copy and paste. Query Analyzer does it for you for free...

This...

Dear Kumaran Govender,

please, please read this article again.

Run an example or two.

This technique was tested and works. It does work!!!

You will enjoy...

Best regards

Yakov

Dear SeekQuel,

please read this article again.

Run an example or two.

This technique was tested and works. It does work!!!

You will enjoy...

Best regards

Yakov

Dear David,

thanks for your contribution.

I found and read the snippet you mentioned. There is a fundamental difference between my article and this snippet. I wrote in details (step by step)...

Dear Graham,

thanks for your contribution.

I found and read the snippet you mentioned. There is a fundamental difference between my article and this snippet. I wrote in details (step by step)...