Click here to Skip to main content
14,668,602 members
Rate this:
Please Sign up or sign in to vote.
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.
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.[^]
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