I want to avoid dynamic pivot in SQL Server.

I want following data from select query in sql server 2005?

• NULL Bank OD accounts Loans (Liabilities) 0.00 NULL Branch / Divisions NULL 0.00 NULL Capital Account NULL 0.00 NULL Current Assets NULL 0.00 NULL Current Liabilities NULL 0.00 NULL Deposits (Asset) Current Assets 0.00 NULL Duties & Taxes Current Liabilities 0.00 NULL Expenses Direct NULL 0.00 NULL Expenses InDirect NULL 0.00 NULL Fixed Assets NULL 0.00 NULL Income Direct NULL 0.00 NULL Income Indirect NULL 0.00 NULL Investments NULL 0.00 NULL Loans & Advances Current Assets 0.00 NULL Loans (Liabilities) NULL 0.00 NULL Misc. Expenses NULL 0.00 NULL Provisions Current Liabilities 0.00 NULL Reserves & Surplus Capital Account 0.00 NULL Secured Loans Loans (Liabilities) 0.00 NULL Stock-in-hand Current Assets 0.00 NULL Sundry Debtors Current Assets 0.00 NULL Suspense Account NULL 0.00 Abhishek Industries Sundry Creditors Current Liabilities 0.00 Asarwa Mills Sundry Creditors Current Liabilities 0.00 Balaji Enterprise Sundry Creditors Current Liabilities 0.00 Cash Account Cash-in-hand Current Assets 0.00 ABC Sundry Creditors Current Liabilities 0.00 Himanshu UnSecured Loans Loans (Liabilities) 0.00 Induson International Sundry Creditors Current Liabilities 0.00 Menta Brothers Sundry Creditors Current Liabilities 0.00 NNS Bank Accounts Current Assets 0.00 Purchase Account Purchase Account NULL 0.00 Sagar Textile Sundry Creditors Current Liabilities 0.00 Sales Account Sales Account NULL 0.00 i want select query to get follwoing data from above data NULL Bank OD accounts Loans (Liabilities) 0.00 NULL Branch / Divisions NULL 0.00 NULL Deposits (Asset) Current Assets 0.00 NULL Duties & Taxes Current Liabilities 0.00 NULL Expenses Direct NULL 0.00 NULL Expenses InDirect NULL 0.00 NULL Fixed Assets NULL 0.00 NULL Income Direct NULL 0.00 NULL Income Indirect NULL 0.00 NULL Investments NULL 0.00 NULL Loans & Advances Current Assets 0.00 NULL Misc. Expenses NULL 0.00 NULL Provisions Current Liabilities 0.00 NULL Reserves & Surplus Capital Account 0.00 NULL Secured Loans Loans (Liabilities) 0.00 NULL Stock-in-hand Current Assets 0.00 NULL Sundry Debtors Current Assets 0.00 NULL Suspense Account NULL 0.00 Abhishek Industries Sundry Creditors Current Liabilities 0.00 Asarwa Mills Sundry Creditors Current Liabilities 0.00 Balaji Enterprise Sundry Creditors Current Liabilities 0.00 Cash Account Cash-in-hand Current Assets 0.00 ABC Sundry Creditors Current Liabilities 0.00 Himanshu UnSecured Loans Loans (Liabilities) 0.00 Induson International Sundry Creditors Current Liabilities 0.00 Menta Brothers Sundry Creditors Current Liabilities 0.00 NNS Bank Accounts Current Assets 0.00 Purchase Account Purchase Account NULL 0.00 Sagar Textile Sundry Creditors Current Liabilities 0.00 Sales Account Sales Account NULL 0.00

• Answer:

  Maybe I'm missing something, but looks like your result set of data is the same as the whole, which would be easily gotten via SELECT * FROM someTable