Re: Getting accurate counts - Hire a programmer!

[Dave Thorburn <thorburn@CONL.NET>]

I think you need to hire a programmer.

Best of Luck,

Dave

------------------------------------------------------

>--- Original Message ---
>From: Sayre John <John_Sayre@GAP.COM>
>To: SQR-USERS@list.iex.net
>Date: 12/5/00 5:09:21 PM
>

>I need to be able to count the number of stores which have sold
our products
>by store & by item.  The way our tables are set up, product
lies in the product
>dimension and sales are in  weekly sales table and the two are
joined by
>product key. The complications are these:
>
>Products may be sold at Reg or Markdown
>I need to report on 'Program' not product key. This is clothing,
so a specific
>shirt (program)  might have many colors (style-color--this is
the product key)
>
>trpd_DIM (PRODUCT)                            tssw_sls_fct
>___________________                           ___________
>prd_key       (primary key)                    time_key
>pgm_desc                                                location_key
>
         prd_key
>
         price_key
>
>How do I get accurate counts of how many stores had sales for
each program?
>
>
----------------
Sent from a WebBox - http://www.webbox.com
FREE Web based Email, Files, Bookmarks, Calendar, People and
Great Ways to Share them with Others!