Allineare tutti i dati in una sola riga di result

 Il codice sorgente non è stato renderizzato qui
perchè non c'è sufficiente spazio.
Clicca qui per visualizzarlo in una nuova finestra

USE Trinity
GO

WITH 
W01 AS 
(
SELECT     
Id_prat, Id_scheda, 
ROW_NUMBER() OVER (PARTITION BY Id_prat ORDER BY Id_scheda) AS RowN
FROM         
dbo.Pratiche_righe
), 

W03 AS 
(
SELECT     
Id_prat, 
CASE WHEN RowN = 1 THEN Id_scheda END AS r01, 
CASE WHEN RowN = 2 THEN Id_scheda END AS r02, 
CASE WHEN RowN = 3 THEN Id_scheda END AS r03, 
CASE WHEN RowN = 4 THEN Id_scheda END AS r04, 
CASE WHEN RowN = 5 THEN Id_scheda END AS r05, 
CASE WHEN RowN = 6 THEN Id_scheda END AS r06, 
CASE WHEN RowN = 7 THEN Id_scheda END AS r07, 
CASE WHEN RowN = 8 THEN Id_scheda END AS r08, 
CASE WHEN RowN = 9 THEN Id_scheda END AS r09, 
CASE WHEN RowN = 10 THEN Id_scheda END AS r10, 
CASE WHEN RowN = 11 THEN Id_scheda END AS r11, 
CASE WHEN RowN = 12 THEN Id_scheda END AS r12
FROM         
W01
), 

W05 AS 
(
SELECT     
Id_prat, 
SUM(r01) AS s01, 
SUM(r02) AS s02, 
SUM(r03) AS s03, 
SUM(r04) AS s04, 
SUM(r05) AS s05, 
SUM(r06) AS s06, 
SUM(r07) AS s07, 
SUM(r08) AS s08, 
SUM(r09) AS s09, 
SUM(r10) AS s10, 
SUM(r11) AS s11, 
SUM(r12) AS s12
FROM         
W03
GROUP BY 
Id_prat
), 

W07 AS 
(
SELECT     
dbo.Pratiche.Id_prat, 
dbo.Pratiche.Id_clie, 
W05.s01, 
W05.s02, 
W05.s03, 
W05.s04, 
W05.s05, 
W05.s06, 
W05.s07, 
W05.s08, 
W05.s09, 
W05.s10, 
W05.s11, 
W05.s12
FROM         
dbo.Pratiche 
LEFT OUTER JOIN 
W05 
ON 
dbo.Pratiche.Id_prat = W05.Id_prat
)

SELECT * FROM W07