Thanks for the tip.

Only curious, is it possible to create the second table, from the first one with single query?

i have updated my post. it was never my intention to make you do my job, sorry for the misunderstanding.

this was my first topic here 🙂

WayneS (6/22/2010)

---

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to...

lmu92 (6/22/2010)

---

I'm not sure what the DDL for the transaction table looks like... Table def, sample data and expected result would help a lot here...

I'd probably use "ROW_NUMBER() OVER(PARTITION BY...

Hi,

i can group by and find counts, thats no problem.

The problem is, i need to find the time period between customers transactions.

How to find, daily frequency for example. But day...