sql server - How to use custom display using pivot query -

-

I am currently using this question using PIVOT as the table: 

  Name | Total. 01-10-2014 | 02-10-2014 DD | 500 300 200bb. 400 200 | 200 FF | 150 | 100 | 50

Choose from such a question 

  from (Select Colesus (name, 'NO NAME'), name, total, convert (varchar ( 10), date as 1, 105) is date from #temp, where date 1 & gt; = '2014-10-01' and date 1 & lt; = '2014-10-02') D. PIVOT In the form of P (<01-10-2014], [02-10-2014]) for the date of SM (BILAMT) in the form of

me order by RNAME < / Code> is required. And on the total end .. Any help would be appreciated ...

< P> If you know the column list then try it again and you need to convert it to dynamic pivot.