How can I convert a TRANSFORM query in SQLSERVER

Question

question

CoffeeGuru asked Aug 11, '14

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-sql microsoft-access

10 |1200

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

Answer 1 · 2014-08-16T08:31:02Z

Wilfred van Dijk answered Aug 16, '14

have a [look here][1] (or google for "access transform") [1]: http://ewbi.blogs.com/develops/2005/01/access_sql_tran.html

1

10 |1200

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

CoffeeGuru commented · Sep 18, 2014 at 03:51 PM

Thanks for the link, that was so useful..

0 ·

question