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 |
|
s.teegala
Starting Member
1 Post |
 Posted - 2006-03-02 : 21:56:12
|
| Hi,1.I wrote a stored procedure to bring a list of files,2.another stored procedure to bring the path of each file.Now i need to loop through each file in store procedure 1. and run store procedure 2 for every file and store in temp. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-02 : 22:30:30
|
quote:
Originally posted by s.teegala
Hi,1.I wrote a stored procedure to bring a list of files,2.another stored procedure to bring the path of each file.Now i need to loop through each file in store procedure 1. and run store procedure 2 for every file and store in temp.
3. call sp1 and store in temp table or table variable4. call sp2 and store in temp table or table variable5. loop through table in 4, inner loop in table 3or you can have 1 sp to call and incorporate everything in there...HTH--------------------keeping it simple... |
 |
|
|
|
|
|
looping in stored procedure