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.

Increase column in temp table by another table

Home
Forums
SQL

Increase column in temp table by another table

Nikki

Nikki

8yAsked Sep 16, 2018, 7:48 PM856SQL

In a stored procedure , I have 2 temp tables. I created these 2 tables from database dynamically.

First Table #Students(Name NVARCHAR(50))

Second Table #Subjects(Subject NVARCHAR(50))

Rows in #students and #subjects may increase. Kindly suggest me any solution.

I attached a excel file for this

3 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

Code Alone8y ago
Accepted answer
Hi Nikita,
Use curser for the said issue. You can resolve the issue by below
DECLARE @Subject NVARCHAR(50),@sql NVARCHAR(500)
DECLARE Subject CURSOR LOCAL FAST_FORWARD FOR
SELECT DISTINCT Subject FROM #Statics
OPEN Subject
FETCH Subject INTO @Subject
WHILE (@@FETCH_STATUS = 0)
Begin
SET @Sql = 'ALTER TABLE #Students ADD ['+@Subject+'] DECIMAL(18,2) DEFAULT 0.00 WITH VALUES'
exec (@sql)
FETCH Subject INTO @Subject
end
CLOSE Subject
DEALLOCATE Subject

SELECT * FROM #Students
DROP TABLE #Statics
DROP TABLE #Students
I attach sql file with this answer. I think will solve your issue.
Nikki8y ago
hi Packiaraj Santhiyagu

kindly refer the attahed file in question.
Packiaraj Santhiyagu8y ago
Hi Nikita,

Please give more details about your requirement to assist.
You can create temp table from your table also.
select * into #temp from[dbo].[emp]where 1=2
select * from #temp