View difference between Paste ID: xxAyqRD6 and CkuiyA3t
SHOW: | | - or go back to the newest paste.
1
IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'A') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(23, 'A') END;
2
IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'B') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(8, 'B') END;
3
IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'C') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(5, 'C') END;
4
IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'D') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(0, 'D') END;
5
IF NOT EXISTS (select 1 from dbo.SSProductVatRate where VatSymbol = 'E') BEGIN INSERT INTO dbo.SSProductVatRAte VALUES(0, 'E') END;