Re: How to summarize recordset...Select Distinct alternative?



MP wrote:
I have a table with (lets say) 3 fields: fldFile, fldPage, fldItem
I want a summary report of Items/counts on a per file/ per page basis.
At present I do something more or less like this
(pseudocode ... )

1. Please tell us the type and version of database you are using
2. Show us a few rows of sample data in tabular format - just enough
rows to illustrate your task
3. Show us the results you wish to achieve from that sample data - again
in tabular format
4. Explain the desired results where it isn't obvious.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.



Relevant Pages

  • Re: Select Query Help
    ... tabular format (just the relevant columns - use the smallest number of ... wish to obtain from that sample data, again in tabular format. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: 2nd try, left join
    ... All I can do is repeat my original reply: ... > You're going to need to provide some sample data and desired results ... sample data (also in tabular format). ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: How to summarize recordset...Select Distinct alternative?
    ... Show us a few rows of sample data in tabular format - just enough ... Show us the results you wish to achieve from that sample data - again ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Query help: What is the best and most efficient way to do this
    ... > are over 100,000 records in this format in the source table: ... So did the sample data you provided represent a single row in the source ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: join on 3 tables for asp output
    ... The table structure and sample data is ... >> Mondays since I am scheduling instruments for a whole week. ... > some outer joins (I'm assuming this is SQL Server, ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)