How would i create a sql query to export a list of customer records (just the email addy) plus purchase history
so....
Email, SKU1, SKU2, SKU3
We want to do some analysis in Excel
Many thanks if you can help
How would i create a sql query to export a list of customer records (just the email addy) plus purchase history
so....
Email, SKU1, SKU2, SKU3
We want to do some analysis in Excel
Many thanks if you can help
8.0.1.4 W2008R2 64-bit MSSQL2005
Mike,
the query would be easier if each item was its own row, I will post a query for you to use in commander shortly.
Simrun AspDotNetStoreFront Development
Preferred AspDotnetStorefront Development Partner
ahsan[@]simrun[.]com
remove the "[]" for email
Have a Nice Day
ok thanks very much - what is commander btw ?
We are simply trying to filter emails into mailing lists based on what they have previously bought....we can then email offers/promos for related products that they haven't yet bought
Thanks for your help
8.0.1.4 W2008R2 64-bit MSSQL2005
Was the query ever provided to you?