Update set row number

Thanks, Dave. This seems like "data you would want to derive upon retrieval". Tom, Thanks for confirming my suspicion that I can't do this in a single statement in 8.

For the record, I'm only defaulting the value of the ord column. It can be updated to allow for ordering that is different than the natural text ordering. David, like Tom said, it is still data you would want to derive upon retrieval. Regarding this method, we should underline the following significant points.

If the subquery finds more than one matched row, the update query will return an error, as shown below:. In this article, we learned to update the data in a table with the data where they are contained in other tables. PersonId INT. PersonName , PersonLastName. N 'Salvador' , N 'Williams' ,. N 'Lawrence' , N 'Brown' ,. N 'Gilbert' , N 'Jones' ,.

N 'Ernest' , N 'Smith' ,. N 'Jorge' , N 'Johnson'. PersonId , PostCode , City. City ,. AddressList Addr. ON Per. ON Addr. PostCode ,.

City ;. Rumburak, June 12, - pm UTC. Oh Tom, first time that I have to disagree! They helped me so much in my Apex-Apps when I use the automatic row processing feature. I hate them. I like simple things done simply Because every time a developer comes up with something really fancy smancy smart and dandy - we get burned I am a developer, I've burned myself so many times.

Thanks very much! Kashif, June 13, - am UTC. That's been my experience anyway. Getting back to SET ROW, I would be interested to know the actual not hypothetical number of unique update statements generated by Rizwan's application.

Don't think it would be in the millions June 13, - pm UTC. I showed how to do it, i was not advocating it. I've written many many times that "this is not the right way", in books even Rizwan already said it would be lots of unique combinations - hundreds at least I would guess. Reader03, June 14, - am UTC.

Any obvious drawbacks or just a feeling? June 14, - am UTC. I don't like magic. I don't like surprises. One mans Magic Mike, June 14, - am UTC. Get a person to pick a single word, from a single article, from a single page, of one of several daily news papers. That word was the same word as written on a piece of paper that had been in an envelope on stage since the start of the show.

To me that seemed like Magic, to the man on stage it was but application of the tools of the trade. Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

Connect and share knowledge within a single location that is structured and easy to search. Tested in dbfiddle. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Learn more. Asked 2 years, 11 months ago.