no of rows in sql stored procedure
-
Hi I want to find out the no of rows returned by a select statement in a stored procedure within the stored procedure ie i have a select statement say select * from employees where deptid=2 now for the no of rows returned i want to perform a calculation for each row in the stored procedure itself how can i loop in it and get the no of rows and the records for each row to handle all these in the stored procedure rather than in the front end Waiting for reply Happy coding Subhash Subhash Chatterji
-
Hi I want to find out the no of rows returned by a select statement in a stored procedure within the stored procedure ie i have a select statement say select * from employees where deptid=2 now for the no of rows returned i want to perform a calculation for each row in the stored procedure itself how can i loop in it and get the no of rows and the records for each row to handle all these in the stored procedure rather than in the front end Waiting for reply Happy coding Subhash Subhash Chatterji
SQL cursor[^] to the rescue! ;)
"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin Edbert Sydney, Australia
-
SQL cursor[^] to the rescue! ;)
"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin Edbert Sydney, Australia
ya i got it thanks