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 insert values from one to another table using while

Home
Forums

how to insert values from one to another table using while

Nandha Kumar Nagarajan

7yAsked Apr 17, 2019, 4:13 AM689

i want to copy values from one table to another table using while loop by row by row

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

Mageshwaran R6y ago
Hi,
try this query:
DECLARE @UserIds TABLE (RowId INT, UserId INT)
DECLARE @Table1 TABLE (UserId INT, CustomerId INT, City VARCHAR(100), [State] VARCHAR(100))

INSERT INTO @UserIds
SELECT 1, 6578
UNION ALL
SELECT 2, 1546
UNION ALL
SELECT 3, 7865



DECLARE @Counter INT, @TotalCount INT, @UserId INT
SET @Counter = 1

SET @TotalCount = (SELECT COUNT(*) FROM @UserIds)

WHILE (@Counter <=@TotalCount)
BEGIN
    SET @UserId = (SELECT UserId FROM @UserIds WHERE RowId = @Counter)

    INSERT INTO @Table1 (UserId, CustomerId, City, [State])
    VALUES (@UserId, 0, 'Miami','Florida')

    SET @Counter = @Counter + 1
    CONTINUE;
END

SELECT * FROM @Table1
0
Madan Shekar7y ago
Here example i given you just change your table name with columns properly
DECLARE @LoopCounter INT = 1, @MaxEmployeeId INT = 3 ,
@EmployeeName NVARCHAR(500)

WHILE(@LoopCounter <= @MaxEmployeeId)
BEGIN
SELECT @EmployeeName = Name,@Empid=id,@empstatus=status
FROM Employee WHERE Id = @LoopCounter

insert into table2name( Id, Name, Status) Values(@Empid,@EmployeeName,@empstatus)
PRINT @Empid,@EmployeeName,@empstatus
SET @LoopCounter = @LoopCounter + 1
END
If it helps please accept the answer in case of any issue ping me
+1