UPDATE dbo.Countries SET LanguageCode='da' WHERE LanguageCode IS NULL AND CountryCode='DK'
UPDATE dbo.Countries SET LanguageCode='no' WHERE LanguageCode IS NULL AND CountryCode='N'
UPDATE dbo.Countries SET LanguageCode='sv' WHERE LanguageCode IS NULL AND CountryCode='S'
UPDATE dbo.Countries SET LanguageCode='en' WHERE LanguageCode IS NULL AND CountryCode='GB'
UPDATE dbo.Countries SET LanguageCode='de' WHERE LanguageCode IS NULL AND CountryCode='D'
UPDATE dbo.Countries SET LanguageCode='pt' WHERE LanguageCode IS NULL AND CountryCode='P'
UPDATE dbo.Countries SET LanguageCode='BE' WHERE LanguageCode IS NULL AND CountryCode='B'
UPDATE dbo.Countries SET LanguageCode='fr' WHERE LanguageCode IS NULL AND CountryCode='F'
UPDATE dbo.Countries SET LanguageCode='is' WHERE LanguageCode IS NULL AND CountryCode='IS'
UPDATE dbo.Countries SET LanguageCode='ie' WHERE LanguageCode IS NULL AND CountryCode='IRL'
UPDATE dbo.Countries SET LanguageCode='es' WHERE LanguageCode IS NULL AND CountryCode='E'
UPDATE dbo.Countries SET LanguageCode='fr' WHERE LanguageCode IS NULL AND CountryCode='FR'
UPDATE dbo.Countries SET LanguageCode='SV' WHERE LanguageCode IS NULL AND CountryCode='SE'

