convert crosstab query to sql 2008

[aqawae]

من یه دیتابیس اکسس دارم میخوام ببرمش روی اسکیول که سه تا crosstab query دارم چطوری میشه به اسکیول تبدیل کرد
-
TRANSFORM Sum(ISSUE.Qty_issue) AS [The Value]
SELECT ISSUE.[Tag_no], Sum(ISSUE.Qty_issue) AS [Total Of Qty_issue]
FROM ISSUE
GROUP BY ISSUE.[Tag_ no]
PIVOT ISSUE.Tmpe;

2-
TRANSFORM Sum(MRV.[Ret-qty]) AS [The Value]
SELECT MRV.[Tag_ no], Sum(MRV.[Ret-qty]) AS [Total Of Ret-qty]
FROM MRV
GROUP BY MRV.[Tag_ no]
PIVOT MRV.TEMP;

3-
TRANSFORM Sum(REC.[Rec-qty]) AS [The Value]
SELECT REC.[Tag_ no], Sum(REC.[Rec-qty]) AS [Total Of Rec-qty]
FROM REC
GROUP BY REC.[Tag_ no]
PIVOT REC.TMPE;

[byazdaani]

تا جایی که من اطلاع دارم pivot از sql 2008 R2 به بعد ساپورت میشه. از فروم sql بپرسی بهتر کمکت میکنن.