Logic Error

Declare @mx int
Set @mx = (select max(score)
from ,,,
where ,,,,and
substring(city,1,1)='g')

select score,@mx
from ,,,,
where ,,,, and
substring(city,1,1)='g')
group by score
go

this seems to work for small tables
but when table is big and substring(city,1,1)='g')
condition is not met it takes aweful time like goes
in an infinit loop.




--
Sent by 3 from yahoo part of com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com