How to loop in Stored Procedure?

Sujeet Raman

My Issue:

i have two student id,based on id i need to return 1 table with student dateils but i should get this table together seperately

id1----sp should return 1 table

id 2...2nd table

I need to use this 2 temp table as a data table in c# .Now my sp returning student details in 1 temp table

idea is like :

SELECT @studentid= select * FROM studenttable

for(i=0;i

create temptable(I) ---------------if 2 id 2 table shud return in 1 sp

}

3 Replies

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

Hamid Khan6y ago
Please use this link :
https://stackoverflow.com/questions/22435195/loop-in-stored-procedure-in-sql-server
Sujeet Raman6y ago
Hi I tried this but getting error like

: 'There is already an object named 'temp' in the database.temp is my finl result table

All joins table i am adding to temp table to return as a result

and in the counter part, i cannot convert it.(student id randomly getting to sp from checkbox)

System.Data.SqlClient.SqlException: 'Conversion failed when converting the nvarchar value '200,245' to data type int.'
DECLARE @Counter nvarchar(100), , @MaxId nvarchar(100),
@studentId varchar(50)
SELECT @studentid= Replace(isnull(datachar,-1),'~' ,',') from studenttable where sessionid=@sessionid
FROM studenttable
SELECT @Counter = min(@studentid) , @MaxId = max(studentid)
FROM studenttable
WHILE(@Counter IS NOT NULL
AND @Counter <= @MaxId)
BEGIN
.
"result return in "temp" table
END
Navaneeth Krishnan6y ago
try while loop in sql

example
USE tempdb
GO
DECLARE @Counter INT , @MaxId INT,
@CountryName NVARCHAR(100)
SELECT @Counter = min(Id) , @MaxId = max(Id)
FROM SampleTable
WHILE(@Counter IS NOT NULL
AND @Counter <= @MaxId)
BEGIN
SELECT @CountryName = CountryName
FROM SampleTable WHERE Id = @Counter
PRINT CONVERT(VARCHAR,@Counter) + '. country name is ' + @CountryName
SET @Counter = @Counter + 1
END
https://www.sqlshack.com/sql-while-loop-with-simple-examples/