Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to pivot bellow table??

Home
Forums

How to pivot bellow table??

Maharudra Gadekar

Maharudra Gadekar

9yAsked Mar 20, 2017, 6:36 AM820

Hello,

I want to convert my table out in as column name to row values are as follows:

id code column1 col2 col3 col4 col5

1 1 1 5 12 12 12 12

nut i want the below output as follws:

id code columnaame values

1 1 column1 15

1 1 Column1 12

1 1 Column1 12

1 1 Column1 12

and so on

please help me

thanks in advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

John9y ago
CREATE TABLE [dbo].[codeex](
[id] [int] NULL,
[code] [int] NULL,
[col1] [int] NULL,
[col2] [int] NULL,
[col3] [int] NULL,
[col4] [int] NULL,
[col5] [int] NULL
)

select id,code,colname,value
from codeex
unpivot
(
value
for colname in (col1, col2,col3,col4)
) u