samedi 1 août 2015

Why I can't reference to WITH expression more than one time?

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