sql server programming: How do I generate a random number between 1 and 10?

I need to capture information of potential clients and
randomly assign them to salespersons.

Just a though, why assign them randomly, rather than distributing new =
clients among the salespeople who have the least clients?


[quoted text, click to view]
How do I generate a random number between 1 and 10?

I need to capture information of potential clients and=20
randomly assign them to salespersons.

Thanks.