Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Report

  1. 11-21-2010, 02:27 PM #1
    newtothis is offline Senior Member
    Join Date
    Mar 2009
    Posts
    200

    Default Report

    Hi All,

    Does anyone know how to run a custom report which will bring back the most regular customers? i.e. customers who have had the most orders.

    Many thanks
  2. 11-23-2010, 01:10 AM #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    Code:
    select customerid, count(*) 
from orders with (nolock)
group by customerid
order by 2 desc
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!