>Hi,
>I have an accounting table with 5 year of data for an account, the table headers look as following
>
>Acctno___Year___db_1,db_2,db,db_3,db4,….db_12,Cr_1,cr_2,cr_3…,cr-12
>
>I want to with select statement to convert the data to query the header must be the following:-
>
> Years1___Year2___year3___year4____year5
>Db_1
>Db_2
>Db_3
>.
>.
>.
>
>Thanks for any help

If this can wait a bit, I can find examples from "Programming SQL Server" book I have at home. In the meantime you can google for "PIVOT SQL Server 2005" as Sergey advised.