<div>
Thanks for your answer, it is excellent.
</div>


<div>
<div class="content wysiwyg-content">
I've a table which got the data as below example: I need to organize the data according to the <br />
sample below. I really appreciate if you can help me to write a SQL query to achieve this.<br />
<br />
<br />
Table:<br />
<br />
process_date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;transaction_from_date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; transaction_to_date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;rate &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
<br />
DAY4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DAY1 &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DAY3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;100.00<br />
DAY6 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;--- &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-- &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50.00 &nbsp;<br />
<br />
Require data format:<br />
<br />
DATE &nbsp; &nbsp; &nbsp; &nbsp; rate<br />
day1 &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; <br />
day2 &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp;<br />
day3 &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp;<br />
day4<br />
day5<br />
day6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50<br />
-<br />
-<br />
-<br />
-<br />
-<br />
-<br />
day31<br />

</div>
</div>


I've a table which got the data as below example: I need to organize the data according to the 
sample below. I really appreciate if you can help me to write a SQL query to achieve this.


Table:

process_date              transaction_from_date                         transaction_to_date	     rate            

DAY4		                             DAY1     		          DAY3		    100.00
DAY6	   	                               ---		            --                                       50.00  

Require data format:

DATE         rate
day1         100     
day2         100  
day3         100  
day4
day5
day6          50
-
-
-
-
-
-
day31


Derive information from a transaction table and unpivote the information on SQL 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.