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

check this SELECT [MailNo], [inboxMessage], [SentMessage] FROM ( write here your query) AS SourceTable PIVOT ( AVG (mailnumber) FOR email IN ([MailNo], [inboxMessage], [SentMessage]) ) AS PivotTable;

I am not good with Sql. I did not understand pivot funcation at all. I wish if you could show me the query in my above context. I would be grateful to you.

HI try this link https://databricks.com/blog/2018/11/01/sql-pivot-converting-rows-to-columns.html https://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query

Answers

Pivot table and insert the data into table

Istudent Rana

732

1 SQL Server

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

Pivot table and insert the data into table

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)