"Fusion" de requêtes [Résolu]

[colonel.klink]

Bonjour,

Je souhaiterais fusionner ces requêtes au sein d'une procédure stockée :

Code :

1
2
3
4
	SELECT Col3 AS Periode,Col2 AS Valeur1 FROM @Tmp WHERE Col1=1 GROUP BY Col3, Col2
	SELECT Col3 AS Periode,Col2 AS Valeur2 FROM @Tmp WHERE Col1=2 GROUP BY Col3, Col2
	SELECT Col3 AS Periode,Col2 AS Valeur3 FROM @Tmp WHERE Col1=3 GROUP BY Col3, Col2
	SELECT Col3 AS Periode,Col2 AS Valeur4 FROM @Tmp WHERE Col1=4 GROUP BY Col3, Col2

Merci par avance.

[colonel.klink]

Réalisé en utilisant :

Code :

1
2
3
4
5
6
7
	SELECT Col3 AS Periode, 
		SUM(CASE WHEN Col1=1 then Col2 else 0 end) AS Valeur1, 
		SUM(CASE WHEN Col1=2 then Col2 else 0 end) AS Valeur2, 		
		SUM(CASE WHEN Col1=3 then Col2 else 0 end) AS Valeur3, 	
		SUM(CASE WHEN Col1=4 then Col2 else 0 end) AS Valeur4
	FROM @Tmp
	GROUP BY Col3