Bonjours à tous!
J'ai un problem ici avec une Proc Stockée que je suis en train de construire.
WHILE (@loop <= @i)
BEGIN
SET @fld_list = @fld_list + (SELECT TOP
@loop F FROM (
SELECT TOP
@i REPLACE(REPLACE(REPLACE(TABLE_NAME,'ut_RptRetailSaleSCumulQte','A'),'ut_RptRetailSaleSCumulProfit','B'),'ut_RptRetailSaleSCumulSales','C') + '.' + COLUMN_NAME + ',' AS F
FROM information_schema.columns
WHERE TABLE_NAME IN ('ut_RptRetailSaleSCumulQte', 'ut_RptRetailSaleSCumulProfit', 'ut_RptRetailSaleSCumulSales')
AND COLUMN_NAME<>'Style'
ORDER BY F DESC
) t2 ORDER BY F ASC)
SET @loop = @loop + 1
print(@fld_list)
END
Elle me retourne les erreur suivante :
Msg 102, Level 15, State 1, Procedure sp_RptRetailSalesCumul, Line 61
Incorrect syntax near '@loop'.
Msg 102, Level 15, State 1, Procedure sp_RptRetailSalesCumul, Line 62
Incorrect syntax near '@i'.
Quelqu'un sait comment regler ce probleme?