Displaying monthwise sales details

this is called crosstab process, for which you can use the SQL Server 2005 TRANSFORM + PIVOT syntax, or some procedure like this in general:
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1131829,00.html?FromTaxonomy=%2Fpr%2F301764

if you want it for 1 year (12 months), something like this:


select dealer_id
, sum ( case when datepart(month, order_date) = 1 then order_price else 0 end ) as Jan05
, sum ( case when datepart(month, order_date) = 2 then order_price else 0 end ) as Fev05
, sum ( case when datepart(month, order_date) = 3 then order_price else 0 end ) as Mar05
...
FROM yourtable
where order_date >= convert(datetime, '2005-01-01', 120) and order_date < convert(datetime, '2006-01-01', 120)
group by dealer_id

Thanks for your response.

BUT, based on the dates provided only that number of months should be displayed.
For example if 01/01/2005 and 06/01/2005 are provided only 6 months should be show not the 12 months and 0s from the seventh month.

One more example
say if the dates passed are 03/02/06 and 07/02/06  then only months March,April, may june, july should be shown.

Pls help

then you have to use the crosstab function (link is above), as this is a dynamic query (variable number of columns)

Hello imran_fast,

there is an issue with this. though we are declaring @query it is again giving me an error saying @query must be declared.

pls help