Thanks Everyone

david,

Thank you. that worked perfectly.

Matt

kenneth,

I use entry as in enter their name into a contest. Based on the amount they purchase as the number of entries into the contest. the selection is still random...

I think I will start running those procs.

The best thing to do with a non-technical manager is confuse him so much that he never asks for a blow-by-blow description again. 

I...

Someway to show the joins and the isnull statements. In the sql statement I am using a leftouter join and if the value if.. here it make more sense with...