Begin tran
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1023')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1023','Food - Other Food',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1124')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1124','Food - Bread',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1125')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1125','Food - Breakfast',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1126')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1126','Food - Chicken - Breakfast',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1127')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1127','Food - Chicken - Grilled Filet',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1128')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1128','Food - Coater',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1129')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1129','Food - Condiments', 1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1130')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1130','Food - Desserts',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1131')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1131','Food - Chicken - Filets',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1132')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1132','Food - Chicken - Nuggets',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1134')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1134','Food - Oil',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1135')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1135','Food - Produce',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1136')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1136','Food - Chicken - Strips',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1137')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1137','Food - Waffle Potato Fries',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1138')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1138','Food - Test Ingredients',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1145')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1145','Food - Chicken - Spicy',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1202')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1202','Food - Chicken - Grilled Nugg',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1275')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1275','Repairs/Maintenance',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1123')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1123','Food - Beverages',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1280')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1280','Health Insurance - Operator',1,NULL,0)
IF NOT EXISTS (SELECT* FROM tbLocalisationData WHERE Section='MxConnect'AND CultureCode=''AND ResourceKey='EOM_Account_1281')INSERT INTO tbLocalisationData(Section,ResourceType,CultureCode,ResourceKey,ResourceValue,UserEditable,Comment,SpecialType)VALUES('MxConnect','EndOfMonth','','EOM_Account_1281','Cleaning Crews',1,NULL,0)
--commit
--rollback


SELECT * FROM tbLocalisationData WHERE Section = 'MxConnect' 
and ResourceType = 'EndOfMonth' and ResourceKey like '%EOM_PercentDollars%'
order by ResourceKey asc

begin tran
insert into tbLocalisationData values('MxConnect','EndOfMonth','','EOM_PercentDollars','% Dollars',1,null,0)
--commit
--rollback

--IF NOT EXISTS (SELECT * FROM tbLocalisationData WHERE Section = 'MxConnect' AND CultureCode = '' AND ResourceKey = 'EOM_Account_1275')   INSERT INTO tbLocalisationData (Section, ResourceType, CultureCode, ResourceKey, ResourceValue, UserEditable, Comment, SpecialType)   VALUES ('MxConnect', 'EndOfMonth', '', 'EOM_Account_1275', 'Repairs/Maintenance', 1, NULL, 0)  