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 2000 Forums  SQL Server Development (2000)  retreiving multiple records from table......

Author  Topic  hmusa Starting Member 36 Posts Posted - 2001-02-26 : 07:56:23 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 CRA85000005 85D047 26EEDP 50PP0007 CRA85000005 85D047 26EEDP 50PP0007 KNI85000006 85D089 50EEMM 31PM0018 KNI85000006 85D089 50EEMM 31PM0018 KNI85000006 85D089 50EEMM 31PM0018 KNI85000006 85D089 50EEMM 31PM0018 OST86000009 86D752 50EPCM 31PM0020 OST86000009 86D752 50EPCM 31PM0020 OST86000009 86D752 50EPCM 31PM0020 OST86000009 86D752 50EPCM 31PM0020 OST86000009 86D752 Z20AEN 30NY0002 Any Ideas.... Many thanks