Webmaster Forum / ASP / Database Access / June 2003

How can I count only unique records in a recordset? (sql server 7.0).
When I do a select query for an asp page, I may have more than 1 record with
the same (for example) STATEMENTID. When I count the records Iwant to
register only 1 record increment for each unique STATEMENTID.

I have the following code:
biddate = request("close_month") & "/" & request("close_day") & "/" &
request("close_year")
bidtime = request("close_time") & " " & request("close_ampm")