Sql in store procedure how to pass multple values using for loop

Question

hi
I pass mobile numer in that i having diffirent query id
i need to pass query id in same store procedure in other sql select state ment using where codition need pass query id and get that related values in for loop

Nitin Sontakke · Answer

I believe what you need is a cursor. Have you had a look at that at all?   Cursor in Microsoft SQL Server

Thulasiram pakala · Answer

Query id is QR001 ,QR002,QR003 one mobile no i pass mobile no i want to get quesry id in select * From Tale and that query id need to pass in SP like this

select * from table
i should loop here
{
exec doLogic table.Id -- and pass each tableId inside

}

Nitin Sontakke · Answer

Unfortunately, it is not quite clear what you are trying achieve here.   Is it possible to give some example, please?