forum.venkateswarlu.net
      Register      Login
Spliting one column to multiple columns

1 replies to this topic

Karna S #1
Member
22 Points
 Posted on 18 Jun 2013 02:53 PM IST

Hi,

I have one column

Value

10
20
30

i need to convert this column like this

V1    V2   V3

10    20   30

How to solve this?
so any one Help me 
SQL Server     814 views     Reply to this topic
Subramaniam R #2
Member
152 Points
 Replied on 16 Jul 2013 03:28 PM IST using pivot function we can acheive this output. please try to browse about sql server pivot in the internet 
Reply to this topic