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