Home Forums Older Versions of SQL (v6.5, v6.0, v4.2) Older Versions of SQL (v6.5, v6.0, v4.2) Taking rows RegID Date (Registration with multiple dates) and changing format to columns) RE: Taking rows RegID Date (Registration with multiple dates) and changing format to columns)
Debbie Edwards
SSCrazy Eights
Points: 9217
More actions
March 18, 2009 at 3:14 am
#961659
Whoops sorry about that.
I used an old create table script and didnt finish it properly.
Thanks for the advice. I think I used MIN, MAX and then grabbed the other ID that isnt in the min OR MAX temporaty tables.
Debbie