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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-26 : 23:08:17
|
hanif writes "I have a table with 1 million records, their can be a minimum of 3 records attached to one student, I need a way to step through the dataset selecting all records that pertain to a student and then run a process that will allow me to enter a variable into a field on the same table depending on a given criteria within the records retrieved, this process must be returned on all students.
a copy of some of the data is below:
StudentID
GOS84000002 84S574 25EEDP 50PP0006 1996 1 L
CRA85000005 85D047 26EEDP 50PP0007 1996 1 L
CRA85000005 85D047 26EEDP 50PP0007 1997 1 L
KNI85000006 85D089 50EEMM 31PM0018 1996 1 L
KNI85000006 85D089 50EEMM 31PM0018 1997 2 L
KNI85000006 85D089 50EEMM 31PM0018 1998 3 L
KNI85000006 85D089 50EEMM 31PM0018 1999 4 L
OST86000009 86D752 50EPCM 31PM0020 1997 1 P
OST86000009 86D752 50EPCM 31PM0020 1998 2 P
OST86000009 86D752 50EPCM 31PM0020 1999 3 P
OST86000009 86D752 50EPCM 31PM0020 2000 4 P
OST86000009 86D752 Z20AEN 30NY0002 1996 1 P
" |
|
|
|
|
|
retrieving multiple records from a table to use with cursors