RE: update X rows of column

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 10/20/04 

Date: Wed, 20 Oct 2004 09:35:39 -0700

I would still want to allocate them in a logical order if only because I
don't like things that are indeterminate - testing is much simpler without
that sort of problem.

Maybe you should allocate calls in the order that the lead was obtained
(perhaps you wouldn't want old leads languishing in the database longer than
necessary). Also, is it essential to pre-allocate all 10? Why not assign each
one as it's required? Otherwise if the user only completes 9 calls won't
he/she have to de-allocate a call (and meantime no-one else has been able to
follow that one up)? 

-- 
David Portas
SQL Server MVP
--
Loading