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 |
|
Jeba_Antony
Starting Member
2 Posts |
 Posted - 2006-12-07 : 23:55:00
|
| Hai friends,In my application i want to update the 11 players score(11 rows) in stored procedure.that is 11 players been updated based on the user id.for update i am having the parameters user ID and 11 player scores.So initially i am getting the corresponding 11 players auto ID.ex. select player_id from mytable where user_id=@uidso now i have 11 player ids.My doubt is, how to update the 11 players score one bye one based on the auto id.is it possible one loop (while @i <=11)Thanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-08 : 03:00:27
|
| Can you post some sample data and the result you want?MadhivananFailing to plan is Planning to fail |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-08 : 15:30:39
|
| Normalize your database design and call stored procedure 11 times to update one and each new score.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
Update Records