MSSQL Iterate through records and insert into another table.

Job ID: 37601464

Budget: $10 – $40 AUD

Currently have a query, which groups some sales data Select Top 100.

Need it to iterate through all customers from the customers table and run this query 'per customer'.

Then insert this data into another table.

This is running in MSSQL.

See 2 screen shots for current query and for data returned.

I need this done now, so if you can't do it, please don't bid.
Related categories: SQL Microsoft SQL Server