I would say if you want top selling five items you could do something like Select top(5) from Products where category='somecategory' order by SalesNumbers DESC not this syntax might not be right; I don't have a computer with enterprise manager installed on it right here to check it.
Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 8:35 AM To: [email protected] Subject: Re: [AspNetAnyQuestionIsOk] Timeout expired........ Thanks for reply.... I am developing a website of e-commerce. and database has 16000 records. actually I have 3 tables. and all 3 tables contain details of products. productid is primary key for all 3 tables. all 3 tables contain detail of different products but some products are same and i have to display that product in my site. so i have to find productid which is common in all 3 tables. so i have to access all data. and i have to display top 5 selled product. my database knowledge is not so good. so pls help me... --- Dean Fiala <[EMAIL PROTECTED]> wrote: > I'd ask why a user would need or even want 16,000 > records on a single > page. If you need to perform some sort of batch > work on the records, > do it in the database or in a class in a separate > thread. > > > From: [email protected] > > [mailto:[EMAIL PROTECTED] On > Behalf Of nidhi upadhyay > > Sent: Monday, November 07, 2005 11:36 PM > > To: [email protected] > > Subject: [AspNetAnyQuestionIsOk] Timeout > expired........ > > > > > > hi... > > > > I m working with sqlserver database.and > database has 16000 records. > > I m developing web site. > > but when i will try to run first page then > sometimes...it displays > > following error.. > > > > "Timeout expired. The timeout period elapsed prior > to completion of the > > operation or the server is not responding. " > > > > On this page I have to fetch all 16000 > records. > > > > pls help me.......................... > > > > > > --------------------------------- > > Enjoy this Diwali with Y! India Click here > > > > [Non-text portions of this message have been > removed] > > > > > > > > > > SPONSORED LINKS > > Basic > > > <http://groups.yahoo.com/gads?t=ms&k=Basic+programming+language&w1=Basic+pro > > > gramming+language&w2=Computer+programming+languages&w3=Programming+languages > > > &w4=Java+programming+language&c=4&s=126&.sig=bnac3LCZpttb3c9FvbVU-A> > > programming language Computer > > > <http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=Basic > > > +programming+language&w2=Computer+programming+languages&w3=Programming+langu > > > ages&w4=Java+programming+language&c=4&s=126&.sig=1Czd2hKCO9_u4KVZQperFQ> > > programming languages Programming > > > <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Basic+programm > > > ing+language&w2=Computer+programming+languages&w3=Programming+languages&w4=J > > > ava+programming+language&c=4&s=126&.sig=TyHGCjod4YOKITrSq1xccQ> > languages > > > > Java > > > <http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Basic+prog > > > ramming+language&w2=Computer+programming+languages&w3=Programming+languages& > > > w4=Java+programming+language&c=4&s=126&.sig=PZAexF9LyXpKb3HDJSlB1g> > > programming language > > > > _____ > > > > YAHOO! GROUPS LINKS > > > > > > > > * Visit your group "AspNetAnyQuestionIsOk > > > <http://groups.yahoo.com/group/AspNetAnyQuestionIsOk> > " on the web. > > > > > > * To unsubscribe from this group, send an > email to: > > [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED] > > e> > > > > > > * Your use of Yahoo! Groups is subject to > the Yahoo! Terms of Service > > <http://docs.yahoo.com/info/terms/> . > > > > > > _____ > > > > > > > > > > [Non-text portions of this message have been > removed] > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > -- > Dean Fiala > Very Practical Software, Inc > http://www.vpsw.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Yahoo! Groups Links ************************************************************************* This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. ************************************************************************* ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
