Improvements

Bugfixes

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 = d.id - Empowering identity building and community growth through DID. 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