Recent content by spud101

Yes, that's very good and works. I'm not going to pretend i understand it. Any recommendations on good books? Thanks again Tim

Still don't get it. I don't get the correct information back, without even getting into the joins. I'm familiar with MS SQL aggregates which requires all fields in the group by clause, but I don't know how MSSQL handles it. All I know is the data is incorrect. Here's a snippet of what I get...

I'm not sure what you're hinting at. select min(laptime) , track from laptimes group by track returns the quickest time at each track but not the drivername who ran it. select min(qualifytime) , track, driver_id from points_db...

Ok, boys and girs...easy problem for you, hard problem for me. I need help finding out who has fastest laptime from my racing database for each track. I cannot use a subquery. Drivers table driver_id drivername LapTimes Table driver_id laptime track So the info I want to Select is drivername...

Great, thanks for the help. Tim

I'm trying to replace all the double quotes in a string with 2 double quotes. Ex. this is a "string" with quotes I want to change it to this: this is a ""string"" with quotes The replace function gives me an error when i use it like this...

I've had to re-install my w2000 server operating system and SQL 7, but i can't connect to the SQL server over the internet. Things were working before the re-install and I am wondering whether I missed a step or something. After installing SP4 and running the client & server network utilities i...

Very Good! Now all I have to do is pick it apart and try to understand how it works. Thanks

I have a race database that contains a table with a field for a lap time and another for the track where the lap was run, and a driver_id field for the driver. I'm trying to use a query to pull the fastest lap time for each track. I can get the info like this : select min(qualifytime),Track...