How to loop in Stored Procedure?

Question

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 }

Hamid Khan · Answer

Please use this link : https://stackoverflow.com/questions/22435195/loop-in-stored-procedure-in-sql-server

Sujeet Raman · Answer

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 BEGIN . "result return in " temp " table END

Navaneeth Krishnan · Answer

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 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/