SQL Help.

~~DirtyMind~~ · 04/05/2013, 10:47

By a mistake I f*cked up my IDs in coloumn Link in refobjcommon. What I need is this : A query which will take all IDs from the original back up of the database ( I have it restored under the SRO_VT_SHARD name) and put them in my new db with condition which says : replace all ids until u reach ID (coloumn name ID) 42000 (example). That's all I hope you get it. Thanks in advance!

IceAmStiel · 04/05/2013, 13:19

Code:

UPDATE dbo._RefObjCommon
SET Link = r2.Link
FROM dbo._RefObjCommon r1
JOIN Backup.dbo._RefObjCommon r2 on r1.ID = r2.ID
WHERE r1.ID <= 42000

~~DirtyMind~~ · 04/05/2013, 17:06

IceAmStiel · 04/05/2013, 19:45

Are you sure that your backup contains all valid Links?

~~DirtyMind~~ · 04/05/2013, 21:08

Quote:

Originally Posted by IceAmStiel

Are you sure that your backup contains all valid Links?

The query worked the problem is that it made the rest of the things with Link 0 ... before that they were okay but now I think I have to rebuild them on the hard way if there is no other way :/

IceAmStiel · 04/05/2013, 21:33

"the rest" I thought it's a backup lol