Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'A') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(23, 'A') END;
- IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'B') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(8, 'B') END;
- IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'C') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(5, 'C') END;
- IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'D') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(0, 'D') END;
- IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'E') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(0, 'E') END;
Add Comment
Please, Sign In to add comment
