Newbie - Moving around (scrambling) data?

[Tim Bird]

"Ricardo Forde" <anonymous@devdex.com> wrote in message
news:e4Ixd9JRDHA.1712@TK2MSFTNGP12.phx.gbl...

> Hi I wodnering what is the best way to move data from 1 row to the next.
> In other words i want to move the firstname from the 50th row to the
> first and that from the first to the 50th....etc, etc.
>
> Any help on this would be great.

Why are you trying to do this?

>
> Thanks a lot.
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Chris Brooksbank]

I would add another column to the table : ALTER TABLE <YourTableName> ADD
MyRowID INT IDENTITY
Looks like you need a temporary row to aid in swapping so add a row and make
note of its MyRowID value , call this <TempRowID>
Then to swap 50th and 1st :

UPDATE <YourTableName> SET FirstName = ( SELECT FirstName FROM
<YourTableName> WHERE MyRowID = 1) WHERE MyRowID = <TempRowID>
UPDATE <YourTableName> SET FirstName = ( SELECT FirstName FROM
<YourTableName> WHERE MyRowID = 50 ) WHERE MyRowID = 1
UPDATE <YourTableName> SET FirstName = ( SELECT FirstName FROM
<YourTableName> WHERE MyRowID = <TempRowID> ) WHERE MyRowID = 50

When finished delete the temp row


- Chris Brooksbank

"Ricardo Forde" <anonymous@devdex.com> wrote in message
news:e4Ixd9JRDHA.1712@TK2MSFTNGP12.phx.gbl...

> Hi I wodnering what is the best way to move data from 1 row to the next.
> In other words i want to move the firstname from the 50th row to the
> first and that from the first to the 50th....etc, etc.
>
> Any help on this would be great.
>
> Thanks a lot.
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[oj]

Aaron has some paging info here... [url]http://www.aspfaq.com/show.asp?id=2120[/url]

--
-oj
RAC v2.2 & QALite!
[url]http://www.rac4sql.net[/url]


"Ricardo Forde" <anonymous@devdex.com> wrote in message
news:e4Ixd9JRDHA.1712@TK2MSFTNGP12.phx.gbl...

> Hi I wodnering what is the best way to move data from 1 row to the next.
> In other words i want to move the firstname from the 50th row to the
> first and that from the first to the 50th....etc, etc.
>
> Any help on this would be great.
>
> Thanks a lot.
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!