Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Do While Loop

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2013-09-05 : 10:33:57
Hi All,

I have created one procedure with Emp_ID parameter. Now I have to
fetch Emp_Id from Emp_Master Table and execute this procedure.

I do not want to use Cursor is there anu other way to do this

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2013-09-05 : 10:38:23
Any other way to do what, exactly? Is it that you want to call this procedure once for every Emp_id in Emp_Master?
If so, then it's best to re-write the procedure to act on all employees as a set rather than on just a single employee.

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -