<snip>
> As a learning exercise could you provide an example?
Doug,
Here you go. Even with an index, its probably less efficient than Jim's query
because of the extra select.
SELECT IdNumber
FROM TheTable p
WHERE NOT EXISTS
(
SELECT IdNumber
FROM TheTable
WHERE IdNumber > p.IdNumber AND IdNumber < (p.IdNumber+99) AND
ROUND(p.IdNumber, -2) = p.IdNumber
)
OR EXISTS
(
SELECT IdNumber
FROM TheTable
WHERE p.IdNumber > IdNumber AND p.IdNumber <= (IdNumber+99)
AND
ROUND(IdNumber, -2) = IdNumber
)
Janet
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2.
Free Trial
http://www.adobe.com/products/coldfusion/flex2/
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2766
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
