Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='additional_services_script.txt';

if @@ROWCOUNT!=0
    BEGIN
        RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1);
        RETURN;
    END
GO

INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723669', 'MTN Data Voucher','R3 (50MB Whatsapp Daily)',3);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723461', 'MTN Data Voucher','R3.5 (35MB Rush Hour)',3.5);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712724024', 'MTN Data Voucher','R5.02 (200MB Facebook Daily)',5.02);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723492', 'MTN Data Voucher','R5.5 (35MB Daily)',5.5);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723478', 'MTN Data Voucher','R6.99 (150MB Rush Hour)',6.99);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723683', 'MTN Data Voucher','R7 (150MB Whatsapp 3 Day)',7);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723676', 'MTN Data Voucher','R7.01 (250MB Whatsapp Daily)',7.01);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723485', 'MTN Data Voucher','R9 (500MB Rush Hour)',9);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712724031', 'MTN Data Voucher','R10 (300MB Facebook Weekly)',10);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723508', 'MTN Data Voucher','R11 (100MB Daily)',11);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712724017', 'MTN Data Voucher','R11.99 (1GB WhatsApp 3 Day)',11.99);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712724833', 'MTN Data Voucher','R12 (300MB Whatsapp Weekly)',12);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723751', 'MTN Data Voucher','R12.01 (1GB Bundle 1 Hour )',12.01);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723546', 'MTN Data Voucher','R15 (80MB Weekly)',15);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723515', 'MTN Data Voucher','R17 (250MB Daily)',17);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723553', 'MTN Data Voucher','R18 (150MB Weekly)',18);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723768', 'MTN Data Voucher','R19.99 (120MB Monthly)',19.99);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723706', 'MTN Data Voucher','R22 (1GB Whatsapp Weekly)',22);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723744', 'MTN Data Voucher','R25 (1GB Facebook Weekly)',25);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723560', 'MTN Data Voucher','R29 (250MB Weekly)',29);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723607', 'MTN Data Voucher','R30 (220MB Monthly)',30);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723522', 'MTN Data Voucher','R32 (1.5GB Daily)',32);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723713', 'MTN Data Voucher','R33 (1GB Whatsapp 20 Day )',33);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723720', 'MTN Data Voucher','R37 (1.2GBWhatsapp Monthly)',37);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723539', 'MTN Data Voucher','R42.5 (1.5GB 3 Day)',42.5);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723829', 'MTN Data Voucher','R55 (3.5GB (500MB X 7 days) EveryDayGigs 1 Week)',55);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723737', 'MTN Data Voucher','R55.01 (2GB Whatsapp Monthly)',55.01);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723577', 'MTN Data Voucher','R69 (1.2GB Weekly)',69);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723775', 'MTN Data Voucher','R79 (1GB Monthly)',79);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723614', 'MTN Data Voucher','R89 (1.2GB Monthly)',89);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723782', 'MTN Data Voucher','R99 (1.5GB Monthly)',99);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723836', 'MTN Data Voucher','R99.01 (7GB (1GB X 7 days) EveryDayGigs 1 Week)',99.01);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723584', 'MTN Data Voucher','R105 (2.5GB Weekly)',105);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723621', 'MTN Data Voucher','R155 (2.5GB+2.5GB Monthly)',155);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723843', 'MTN Data Voucher','R169 (15GB (500MB X 30 days)EveryDayGigs 1 Mntly)',169);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723591', 'MTN Data Voucher','R210 (6GB Weekly)',210);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723638', 'MTN Data Voucher','R215 (3.5GB+3.5GB Monthly)',215);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723980', 'MTN Data Voucher','R269 (30GB Super Data Monthly)',269);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723850', 'MTN Data Voucher','R299 (30GB (1GB X 30 days) EveryDayGigs 1 Mntly)',299);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723645', 'MTN Data Voucher','R299.01 (5.5GB+5.5GB Monthly)',299.01);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723997', 'MTN Data Voucher','R389 (70GB Super Data Monthly)',389);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723867', 'MTN Data Voucher','R399 (60GB (2GB X 30 days) EveryDayGigs 1 Mntly)',399);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712724000', 'MTN Data Voucher','R499 (200GB Super Data Monthly)',499);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723652', 'MTN Data Voucher','R499.01 (12GB+12GB Monthly)',499.01);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723799', 'MTN Data Voucher','R599 (20GB+20GB Monthly)',599);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723874', 'MTN Voice Voucher','R3 (5 Min All Net Voice Daily)',3);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723881', 'MTN Voice Voucher','R5 (10 Min All Net Voice Daily)',5);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723942', 'MTN Voice Voucher','R5.01 (55Min MTN to MTN Daily)',5.01);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723898', 'MTN Voice Voucher','R10 (30 Min All-net Voice Daily)',10);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723904', 'MTN Voice Voucher','R12 (60 Min All-net Voice Daily)',12);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723911', 'MTN Voice Voucher','R20 (120 Min All-net Voice Daily)',20);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723928', 'MTN Voice Voucher','R30 (70 Min All-Net Voice 1 Week )',30);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723959', 'MTN Voice Voucher','R30.01 (280 Min MTN to MTN 1 Week )',30.01);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723966', 'MTN Voice Voucher','R50 (350 Min MTN to MTN Monthly)',50);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723973', 'MTN Voice Voucher','R100 (900 Min MTN to MTN Monthly)',100);
INSERT INTO  AdditionalServiceItem  (Barcode ,Product,Description,Price )   VALUES('6009712723935', 'MTN Voice Voucher','R150 (600 Min All-Net Voice 1 Week )',150);
GO

Print 'Insert into script history if everything else is cool';

Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'additional_services_script.txt');
IF @@ERROR != 0
    BEGIN
        RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
        RETURN;
    END
GO