New Features and fixes for the KODIAK Derivatives Client
Released 20 September 2013
...
EXEC sp_rename @objname = 'ForwardContracts.OriginialContractId', @newname = 'ObsoleteOriginalContractId', @objtype = 'COLUMN'
INSERT INTO Operations (ResultId, OperationTypeId, UserId, DateExecuted) SELECT NettingForwardContractId, 6, MAX(UserId), MAX(ClosingDate) FROM ForwardContracts WHERE NettingForwardContractId IS NOT NULL GROUP BY NettingForwardContractId
INSERT INTO OperationTargets (TargetId, OperationId) SELECT fc.Id, o.Id FROM ForwardContracts fc, Operations o WHERE fc.NettingForwardContractId = o.ResultId
ALTER TABLE ForwardContracts ALTER COLUMN ObsoleteOriginalContractId INT NULL