question

CoffeeGuru avatar image
CoffeeGuru asked

How can I convert a TRANSFORM query in SQLSERVER

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 ;
t-sqlmicrosoft-access
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Wilfred van Dijk avatar image
Wilfred van Dijk answered
have a [look here][1] (or google for "access transform") [1]: http://ewbi.blogs.com/develops/2005/01/access_sql_tran.html
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks for the link, that was so useful..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.