TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Karthik G
NA
16
4.1k
data in more columns should be get into single column
May 18 2016 5:31 AM
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 .
Reply
Answers (
1
)
Generate dynamic colum using sp
Amount to word in sql function??