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.
| 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 OptimizerTG |
 |
|
|
|
|
|
Do While Loop