ASP.NET

MSSQL and ASP Query

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2006

Posts: 2

Reputation: Jon.B is an unknown quantity at this point

Solved Threads: 0

Jon.B

Offline

Newbie Poster

MSSQL and ASP Query

Oct 24th, 2006

Hi All

I am hoping you may be able to help me with a general query I have, I am working on a small script to query our MSSQL database, it is basically a database of search terms, i.e.

Term, Date
help me, 22-10-2006
searchfor, 22-10-2006

What I want to do, and this is more of an query question than VBScript is how I can pull the data from MSSQL to show the most searched for terms, i.e.

Help - exists 302 times in the database
Term - exists 290 times in the database..

I have tried SELECT DISTINCT but that just gives me a number, and I don't know how to count them as they are dynamic.

Any help gratefully appreciated!

Thanks

John

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: MSSQL and ASP Query

Oct 24th, 2006

i think you want:

Help with Code Tags

ASP.NET Syntax (Toggle Plain Text)

select count(term), term from TableName group by term

Quick Reply to Thread

Show Printable Version

Similar Threads

Database Query Help (MS SQL)
ASP Query (ASP)
PHPMyAdmin -> MSSQL (MySQL)
asp mysql (ASP)

Other Threads in the ASP.NET Forum

Previous Thread: Passing values from server-side code to html
Next Thread: adding up checkbox values

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes