Probleme requete imbriquee
Bonjour,
Apres avoir parcouru Google en long et en large, je vous expose mon probleme. Voici tout d'abord le code :
Code:
1 2 3 4 5 6 7 8 9
| SELECT
'P'+CAST(ROW_NUMBER ( ) over (ORDER BY CAST(RIGHT(T1.COLUMN_NAME, 4) as Integer) ASC) as Varchar) as PERIOD,
T1.COLUMN_NAME As FIELDS,
(SELECT TOP 1 T1.COLUMN_NAME FROM GL100112) As DATE
FROM
INFORMATION_SCHEMA.COLUMNS as T1
WHERE (T1.TABLE_NAME='GL100112')
AND (CAST(RIGHT(T1.COLUMN_NAME, 4) as Integer) % 2 > 0)
AND (CAST(RIGHT(T1.COLUMN_NAME, 4) as Integer) between 9 and 31) |
Le probleme dans mon cas est que :
Code:
T1.COLUMN_NAME As FIELDS"
renvoie exactement la meme chose que :
Code:
(SELECT TOP 1 T1.COLUMN_NAME FROM GL100112) As DATE
Pourquoi T1.COLUMN_NAME n'est pas interprete dans la requete ?
Merci d'avance,
Cordialement.