Adapt a transform query to T-SQL view (1 Viewer)

CoffeeGuru

Registered User.
Local time
Today, 11:51
Joined
Jun 20, 2013
Messages
121
Hi Guys how can I accomplish the following:
The below query has been written in Access, I would like to convert that into Sql Server Management Studio 2012

TRANSFORM IIf(Sum([Volume])>0,'X',"") AS Expr1
SELECT CM_DATA.YearWeek
FROM CM_DATA
GROUP BY CM_DATA.YearWeek
ORDER BY CM_DATA.YearWeek DESC
PIVOT CM_DATA.Chain
;


Martin
 

Users who are viewing this thread

Top Bottom