Durrr...yes!

Thanks Steve!

Thats correct. I want a distinct count of every _key_out value in each table in the DB.

Hi Dave,

I think your lag is missing an argument, it just errors out.

I will mess with it though as it does seem perfect for this.

Thanks,

Paul

Will this work?

I think I can do this for all orders, but it would be alot of hopefully unnecessary work.

Interested in your method.

Thanks!

paul

customer_idorder_dateorder_numbervalid

192322007-10-08 00:00:00.0001NULL

192322008-06-12 00:00:00.0002NULL

192322009-07-01 00:00:00.0003NULL

380402009-01-14 00:00:00.0001NULL

380402009-03-16...

Unique per customer..

I think I have it though, kidnof.

I did just upgrade to 2012 RCO (yesterday), but am a little wary of the new functions .

SELECT a.customer_id,...