Converting rows into columns through in SQL

Question

Please find attach an image, I need a general SQL query (for more than two records) I mean not hard coded. Thanks

This could help you http://stackoverflow.com/questions/15745042/efficiently-convert-rows-to-columns-in-sql-server — Sanu Antony, Mar 24 '16 at 06:08
i have tried already but not working, can you plz write down exact query for me?? please — khan, Mar 24 '16 at 06:13
You're creating several accounts to post the [same question](http://stackoverflow.com/questions/36195481/converting-rows-into-columns-in-sql-server-2008-without-using-aggregate-functio)? — James Z, Mar 24 '16 at 18:45
Possible duplicate of [SQL Server dynamic PIVOT query?](https://stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query) — Daniel Bürckner, Jul 04 '18 at 06:30

score 0 · Answer 1 · answered Mar 24 '16 at 12:12

0

--You use sql Pivot to do it. See code bellow

SELECT * FROM ( SELECT ItemCode, ItemName,FrnName,ItmsGrrpCod FROM Table_Name ) AS abc

PIVOT ( COUNT(ItemCode) FOR [ItemName] IN ([ACT00054],[ACT00056],[ALF00001],[FGC00001]) ) AS PV1

answered Mar 24 '16 at 12:12

JonWay

1 Answers1