Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

CSharp TV
Videos
Tech
Articles
Blogs
News
Forums
Books
Events

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.

UNPIVOT with NULL values

Home
Forums

UNPIVOT with NULL values

Martin James

5yAsked Mar 31, 2021, 2:51 PM914

I have the following query :

SELECT Custid, Shipperid, Freight
FROM Sales.FreightTotals
UNPIVOT( Freight FOR Shipperid IN([1],[2],[3]) ) AS U;

I have the following result :

custid shipperid freight

1 1 98

1 3 55

2 2 75

This is my expected output :

custid shipperid freight

1 1 98

1 2 NULL

1 3 55

2 1 NULL

2 2 75

2 3 NULL

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

Amira Bedhiafi5y ago
Accepted answer
1. WITH CTE AS
2. (
3. SELECT custid,
4. ISNULL([1], 0.00) AS [1],
5. ISNULL([2], 0.00) AS [2],
6. ISNULL([3], 0.00) AS [3]
7. FROM Sales.FreightTotals
8. )
9. SELECT custid, shipperid, NULLIF(freight, 0.00) AS freight
10. FROM C
11. UNPIVOT( freight FOR shipperid IN([1],[2],[3]) ) AS U;
+2