請問一下Access的SQL語法轉換到T-SQL的問題

請問下面的語法…如果要用在SQL Server上該如何改寫?
TRANSFORM Sum(tablename.A-tablename.B) AS C
Select tablename.D
FROM tablename
WHERE tablename.E
in (\'aaa\',\'bbb\')
GROUP BY tablename.E,tablename.D
PIVOT Month(tablename.mydate)
1 answer 1