Click here to Skip to main content
14,668,602 members
Rate this:
Please Sign up or sign in to vote.
Hi,
Now i have 32 rows in singles column, how can i get 32 values in a every different single column,i need to get 32 row values from single column into single value from each column, using SQL 2000.
Posted
Comments
Mehdi Gholam 23-Jul-12 2:52am
   
Your question makes little sense, please supply more information.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

You have to use Pivot table.

Please look into the below thread. SatyaPriya Nayak's post will explain you everything in that link.

http://www.c-sharpcorner.com/Forums/Thread/175401/__cs_myImageUpload.asp[^]
   
Comments
Musa.AJ 23-Jul-12 3:03am
   
But in SQl 2000 There is PIVOT option.

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100