Get Umbraco dictionary entries for all languages in a pivoted table (each language with its own column)

GetDictionaryEntries.sql

DECLARE @DynamicColumns NVARCHAR(MAX);
DECLARE @DynamicSQL NVARCHAR(MAX);

SELECT @DynamicColumns = COALESCE(@DynamicColumns+', ', '')+QUOTENAME(languageISOCode)
FROM
(
SELECT DISTINCT
languageISOCode
FROM umbracolanguage
) AS FieldList;

SET @DynamicSQL =
'SELECT [key], ' + @DynamicColumns 
+ ' FROM' 
+ ' ('
+ 'SELECT l.languageISOCode, d.[key], t.[value]'
+ ' FROM cmsDictionary d'
+ ' INNER JOIN cmsLanguageText t ON d.id = t.UniqueId'
+ ' INNER JOIN umbracoLanguage l ON l.id = t.languageId'
+ ') AS sourceTbl PIVOT(MAX([value]) FOR languageisocode IN(' + @DynamicColumns + ')) AS pvt'
+ ' ORDER BY [key];'

execute (@DynamicSQL);