Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ClassyLinks
- Content: Threads
- Order by date
-
Stored Procedure - duplication
Hi all! I've got a stored procedure that is not behaving...or perhaps it is behaving, I just haven't trained it correctly. What I'm TRYING to do is have a list of our top 10 selling items. What is happening is that if an item sells more than once, it appears multiple times in the top 10 list...- ClassyLinks
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Selecting a count based on multiple criteia
Hey all. This is driving me CRAZY!. I'm attempting to count the number of records in a table that meet my criteria. I can get it to work if I only use one condition....but not more. This works: JulLLContactStay = conn.execute("SELECT count(LLID) FROM tblLLContact WHERE LLARea = 1...- ClassyLinks
- Thread
- Replies: 3
- Forum: Microsoft: ASP (Active Server Pages)
