SQLTeam.com | Weblogs | Forums

Customerwise Order Details


I have two tables with me 1 Sales Header 2 Sales Line.

I want Customer wise , First order value, No. of lines-first order , second order value , No.of lines- second order, third order value ,No. of lines- third order value, Increase decrease indicator , Total order value ,total order count..

I am using SQL 2005


Sounds do-able. Could you please post your table definitions (CREATE TABLE statements) so we can help you work on it? Also, whatever query you've worked up so far.