complex query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: ford6 (anonymous_at_discussions.microsoft.com)
Date: 06/08/04 

Date: Mon, 7 Jun 2004 20:21:44 -0700

I have a table that has customers. I have another table
with a record for each individual customer purchase which
includes date of purchase. So repeat customers have
multiple entries in the purchases database. I need to
find out the following: How many customers purchased in a
given month, and for how many was that their first
purchase and for how many was it a repeat? I know that if
I can figure out either how many first time buyers or how
many repeat buyers, and I'll have the other one. The
Current Month AND first purchase part are throwing me.
Does this have to be two queries?

Relevant Pages

  • Re: complex query
    ... > I have a table that has customers. ... > includes date of purchase. ... So repeat customers have ... > I can figure out either how many first time buyers or how ...
    (microsoft.public.sqlserver.programming)
  • [Full-Disclosure] PayPal /webscr currency substitution exploit?
    ... purchase 1000 minutes for about the price of 100...and no, ... Repeat by about a bazillion sites, ... Review allowed form field entries. ... security community often take things to the extreme, ...
    (Full-Disclosure)