In MSSQL I can't reference to WITH expression more than one time?
DECLARE @total FLOAT;
WITH cte AS (
SELECT s.plate, SUM(s.net) AS tonnage
FROM scale s
GROUP BY s.plate
)
SELECT @total = SUM(tonnage) / 100 FROM cte;
SELECT t.*, t.tonnage / @total AS percentage FROM cte t;
Aucun commentaire:
Enregistrer un commentaire