17 lines
965 B
Transact-SQL
17 lines
965 B
Transact-SQL
use envisage
|
|
go
|
|
|
|
begin tran
|
|
if exists (select * from sys.all_columns where name like 'DerivedObjectID' and object_id like OBJECT_ID('[Rate]'))
|
|
begin
|
|
ALTER TABLE Rate DROP COLUMN DerivedObjectID
|
|
ALTER TABLE Rate Add DerivedId uniqueidentifier null
|
|
end
|
|
commit tran
|
|
|
|
Update Rate set DerivedId = '87CC518D-3E08-4754-876E-358DD6354E25' where Id = 'EDD604F0-1836-460C-B60D-E879D24F0E03'
|
|
Update Rate set DerivedId = '87CC518D-3E08-4754-876E-358DD6354E25' where Id = 'D94622AD-B336-4644-9A51-17990E0E0671'
|
|
Update Rate set DerivedId = '73D32C69-6DE9-4892-A26E-A878A228D7F5' where Id = '86CDB478-E973-4B4D-AFA2-A0D1B9FCBBBC'
|
|
Update Rate set DerivedId = 'C3D107D8-6611-4698-A48F-E2B2CD896322' where Id = '8ADE9E54-5C27-40BD-B450-E9C3627166EE'
|
|
Update Rate set DerivedId = '794784CE-CDE3-4BB8-8819-C1FAF73023C2' where Id = '3BA6DBC1-48AF-4E8E-BD69-F9C389AE3A83'
|
|
Update Rate set DerivedId = '13EA9C77-B16B-4BFD-B2D5-D0BF08C20D24' where Id = '5BFC6B19-04E0-4CC7-B0AB-2AE92751E1D0' |