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
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