move row data

I have a row that contains invalid information. I have created another row
with the correct data. each row has a sequence number on it. The other two
fields in each row contain binary data. how can I move the binary data from
one row into the incorrect row and maintain the sequence number that is
already involved?--Record the sequence number of the row with incorrect information, and then
--delete it. Assume incorrect your identified by sequence number 12345
DELETE FROM [YourTable] WHERE [SequenceColumn] = 12345
--Copy the information from the row with the corrected values. Assume row
--with corrected values identified by sequence number 67890
SET INDENTITY_INSERT [YourTable] ON
INSERT INTO [YourTable]
([SequenceColumn] , [Other Columns...]) --must list all columns
SELECT 12345, [Other Columns....]
FROM [YourTable]
WHERE [SequenceColumn] = 667890
SET IDENTITY_INSERT [YourTable] OFF
--Delete the row where corrected values where copied from
DELETE FROM [YourTable] WHERE [SequenceColumn] = 67890
"Dgragg" wrote:

> I have a row that contains invalid information. I have created another ro
w
> with the correct data. each row has a sequence number on it. The other t
wo
> fields in each row contain binary data. how can I move the binary data fr
om
> one row into the incorrect row and maintain the sequence number that is
> already involved?

Move reports created by Report Builder

I have created a number of reports using Report Builder, and I would
like to move them to a new report server 2005 instance (I have
redeployed the underlying model to the new report server) and
associated model. Any easy way to do this?
Thanks,
Paul.Reporting Services Scripter v2
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Paul" <prayner@.matrixbancorp.com> wrote in message
news:1134682199.968299.138840@.o13g2000cwo.googlegroups.com...
>I have created a number of reports using Report Builder, and I would
> like to move them to a new report server 2005 instance (I have
> redeployed the underlying model to the new report server) and
> associated model. Any easy way to do this?
> Thanks,
> Paul.
>|||Thanks very much Jasper! Much appreciated.
Paul.