SQLTeam.com | Weblogs | Forums

Calculating duration between Orders


#1

Hi all,

I have a table with following columns:-

Orderid, Emailaddress, Datecreated, SaleValue

I need to find the duration between new orders to understand how many customers return within 1 week, 2 weeks etc.

Repeat customer need to identify using emailaddress.

Can any one of you help me to write the script to retrieve this info, please?

Regards,
SG


#2

Hi

Please post

  1. Create Sample Data Script

so that we can work on it

Thanks