Hi,
Mabee this can help you:
/****** SQL that selects/inserts the new/missing LocaleStringResource - compares Danish(7) to English(9) ******/
use [databasename]
INSERT INTO [dbo].[Nop_MessageTemplateLocalized]
SELECT t2.[MessageTemplateID]
,9
,[Subject]
,[Body]
,[BCCEmailAddresses]
,[IsActive]
FROM [dbo].[Nop_MessageTemplateLocalized] t2
WHERE t2.LanguageID=7 AND t2.[MessageTemplateID] NOT IN
(SELECT t1.[MessageTemplateID]
FROM [dbo].[Nop_MessageTemplateLocalized] t1
WHERE t1.LanguageID = 9)
also I use this:
/****** SQL that selects/inserts the new/missing LocaleStringResource - compares Danish(7) to English(9) ******/
use slikfabrikken_V1_50_94780
INSERT INTO [dbo].[Nop_LocaleStringResource]
SELECT 9,t2.ResourceName,'' + t2.ResourceValue
--SELECT 9,t2.ResourceName,'TODO: ' + t2.ResourceValue
FROM [dbo].[Nop_LocaleStringResource] t2
WHERE t2.LanguageID=7 AND t2.[ResourceName] NOT IN
(SELECT t1.[ResourceName]
FROM [dbo].[Nop_LocaleStringResource] t1
WHERE t1.LanguageID = 9)
Best regards
http://www.slikfabrikken.dk