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
Istudent Rana
1.4k
344
84.2k
Pivot table and insert the data into table
Apr 30 2019 1:51 AM
This is my situation,
my data in the table is like this
mailnumber
type
email
1
inbox
some inbox message..
1
sent
some sent message..
2
inbox
inbox message
2
sent
sent message
What do i want to achieve is that I want to pivot this data into
mailnumber
inboxMessage
SentMessage
1
some inbox message..
some sent message..
2
inbox message
sent message
and insert the data into new table
Reply
Answers (
3
)
SSIS Iterate through file path and load content from file
want to do Excel "=VLOOKUP(B3;$E$3:$G$11;3;1)" but in SQL