Because certain persons seem to not understand simple questions, I'm going to clarify what I meant. Lets say that you have a table with people's names and addresses in it. What is the best way to write a query that will return the city with the most entries in the table?<BR><BR>Thanks,<BR>Z
rule #1. When requesting information from someone who can actually help you, you will need to put up with any crap they give you. (until you get what you need, then you can tell them to go take a flying ___ )
The only way you can do it is if you KNOW what you mean by most number of questions OR if you want to get x number of results.<BR><BR>So stop being a jackass about it and answer MY questions if you want an answer...stop proving to everyone what a dimwit you are.<BR><BR>Brain Power.
Normally I don't have a problem with people giving me crap, but last night was $2 drink night at a bar I frequent and so consequently my ASP/SQL skills are gone today and I'm not really in the mood to put up with crap.<BR>-Z