1 2 3 4 5 6 7 8 9 10 11 12 13
| declare @DynamicSQL nvarchar(Max)
SELECT @DynamicSQL = COALESCE(@DynamicSQL + CHAR(13) + ' UNION ALL ' + CHAR(13),
'') +
'SELECT dt.[PROPRIETE], dt.[HORODATAGE], dt.[VALEUR] FROM (' +
+'SELECT ' +QUOTENAME(Table_NAME,'''') + '+PROPRIETE AS [COMPTEUR], '
+'VALEUR AS [VALEUR], HORODATAGE AS [HORODATAGE], ROW_NUMBER() OVER (PARTITION BY ' +QUOTENAME(Table_NAME,'''')
+ '+PROPRIETE ORDER BY HORODATAGE DESC) AS RNUM FROM ' +
quotename(Table_schema) + '.' + QUOTENAME(TABLE_NAME) +' WHERE PROPRIETE Like ''%.VA_%'' OR PROPRIETE Like ''%.TA_%'' ) as dt where RNUM = 1'
FROM INFORMATION_SCHEMA.TABLES
WHERE table_name LIKE 'VA%'
--+ '
SELECT @DynamicSQL
Execute(@DynamicSQL) |
Partager