Child pages (Children Display) |
---|
SQL Schema Changes
ALTER FUNCTION [dbo].[GetDealType](@symbol NVARCHAR(50))
RETURNS NVARCHAR(50)
BEGIN
RETURN (SELECT TOP 1 d.Name FROM Instruments i JOIN DealTypes d on i.Type = http://d.Id WHERE Symbol = @symbol)
END
GO
ALTER TABLE ForwardContracts DROP COLUMN DealType
GO
ALTER TABLE ForwardContracts ADD DealType NVARCHAR(50) NULL
GO
UPDATE ForwardContracts SET DealType = dbo.GetDealType(Symbol)
GO