Как выполнить CrossTab на Sql Server? - VB

Формулировка задачи:

Privet. u menja est' vot takaja tablica:

AgrNum	ParamName	ParamValue
----------------------------------
dType	       1
AgrDate	       12/12/2001
Curr	       AMD
Amnt	       25000
Client	       Vv
dType	       2
AgrDate	       10/12/2000
Curr	       USD
Amnt	       10000
Client	       Pp
dGash	       10/12/2002

v access-e s pomoshu crosstab query:

TRANSFORM FIRST([ParamValue]) AS [The VALUE]
SELECT [AgrNum]
FROM Agreement
GROUP BY [AgrNum]
PIVOT [ParamName];

poluchau sleduushee:

AgrNum	AgrDate	        Amnt	Client	Curr	dGash	     dType
1	12/12/2001	25000	Vv	AMD		     1
2	10/12/2000	10000	Pp	USD	10/12/2002   2

kto-nibud' v kurse kak eto mojno povtori' na Sql Server-e Zaranee blagodaru.

Решение задачи: «Как выполнить CrossTab на Sql Server?»

textual
                            Листинг программы 
                        

                            SELECT AgrNum,
    MAX(CASE ParamName WHEN 'dType' THEN ParamValue ELSE NULL END) AS dType,
    MAX(CASE ParamName WHEN 'AgrDate' THEN ParamValue ELSE NULL END) AS AgrDate,
    MAX(CASE ParamName WHEN 'Curr' THEN ParamValue ELSE NULL END) AS Curr,
    MAX(CASE ParamName WHEN 'Amnt' THEN ParamValue ELSE NULL END) AS Amnt,
    MAX(CASE ParamName WHEN 'Client' THEN ParamValue ELSE NULL END) AS Client,
    MAX(CASE ParamName WHEN 'dGash' THEN ParamValue ELSE NULL END) AS dGash
    FROM agreement GROUP BY AgrNum
                        