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.

Output of Pivot in Temp Table

Home
Forums

Output of Pivot in Temp Table

Ramco Ramco

4yAsked Apr 28, 2022, 9:43 AM823

Hi

Is it possible to create Temp table according to Pivot output dynamically & show Grand Total

Below is the output from Pivot. Item can be upto n levels like Item1 , Item2 , Item3, Item4

Name	Item1	Item2
Loc-1	1	1
Loc-2	2	Null

Thanks

2 Replies

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

Ramco Ramco4y ago
Hi Imran

Below code is giving error Incorrect syntax near )

declare @cols as nvarchar(max) = '';
declare @query as nvarchar(max) = '';
select @cols = @cols + QuoteName(itemname) + ',' from (select distinct itemname from #temp)
as tmp

select @cols = substring(@cols,0,len(@cols))
set @query =
'select * into #FinalResult from
(select Name, ' + @cols + ' from (select name,quantity,itemname from #temp) x
pivot (sum(quantity) for itemname in (' + @cols + ')) piv ';
)
execute (@query)

Thanks
Muhammad Imran Ansari4y ago
Yes. Use the following query:
DECLARE @ForGrandTotal VARCHAR(200)
// This is for your all columns in SUM
SELECT @ForGrandTotal = COALESCE(@ForGrandTotal + ',SUM([','SUM([') + [Dscription] + '])'

DECLARE @SQLQuery NVARCHAR(MAX)
SET @SQLQuery =
'SELECT * INTO #FinalResult FROM
(
    // Your PIVOT Query
)
UNION ALL
SELECT ''Grand Total'', ' + @ForGrandTotal + '
FROM #FinalResult
'
EXEC(@SQLQuery)