Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
data in more columns should be get into single column
Karthik G
8y
298
1
Reply
i have one table like
col_1
col_2
col_3
col_4
aa
dd
gg
jj
bb
ee
hh
kk
cc
ff
ii
ll
but i want the result as
Column1
Column2
Column3
Column4
col_1
col_2
col_3
col_4
aa
dd
gg
null
bb
ee
hh
null
cc
ff
ii
null
dd
gg
jj
null
ee
hh
kk
null
ff
ii
ll
null
gg
jj
null
null
hh
kk
null
null
ii
ll
null
null
jj
null
null
null
kk
null
null
null
ll
null
null
null
please any one can answer to this .
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Generate dynamic colum using sp
Amount to word in sql function??