Select Row As Column in SQL

Question

0.00/5 (No votes)

See more:

I Need that
Select SQL ROW
as SQL COLUMNS

Example

SQL

Select
      ProductCode,
      CustomerCode,
      Sum(SALEQTY)
      from PRODUCTSALE group by ProductCode,CustomerCode

ProductCode CustomerCode	SALEQTY
M503DA    	00000001	1
M503DA    	00000002	1
M503DF    	00000003	1
M503DF    	00000004	3
M502DA    	00000005	1
M510CF    	00000006	1
M502DA    	00000007	1
M502DF    	00000008	9
M503DA    	00000009	1
M503DF    	00000010	8
M502DA    	00000011	5
M510CF    	00000012	1
M503DA    	00000013	1
M503DF    	00000014	1
M510CA    	00000015	2
M515CF    	00000016	1
M502DF    	00000017	1

i need Product code As Columns and Value SALEQTY
what should i do ??

Posted 20-Jan-15 16:38pm

saimm

Updated 20-Jan-15 16:40pm

v2

Add a Solution

Comments

[no name] 20-Jan-15 23:18pm

As per ArunRajendra you can use Pivot for your requirement. If it doesnot fulfill your requirement then please mention your requirement properly so that some one can help you properly.

saimm 20-Jan-15 23:25pm

but how product Code select as column
because i dont want to write specific product code becuase it will be change or edit or add
so need smart query
or any dynmaic Query to Select Product code as Columns Names

Select distint(Productcode) from Product

how Select Result of this Query as Columns Names?

saimm 20-Jan-15 23:24pm

but how product Code select as column
because i dont want to write specific product code becuase it will be change or edit or add
so need smart query
or any dynmaic Query to Select Product code as Columns Names

Select distint(Productcode) from Product

how Select Result of this Query as Columns Names?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ArunRajendra · Accepted Answer · 2015-01-20T16:52:00

Solution 1

Use piviot feature. Following are some link for reference.

http://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server[^]
http://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server[^]
Simple Way To Use Pivot In SQL Query[^]
http://technet.microsoft.com/en-in/library/ms177410(v=sql.105).aspx[^]

Posted 20-Jan-15 16:52pm

ArunRajendra

Comments

saimm 20-Jan-15 22:55pm

but how product Code select as column
because i dont want to write specific product code becuase it will be change or edit or add
so need smart query