Derive information from a transaction table and unpivote the information on SQL 2008
Posted on 2011-10-20
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.
process_date transaction_from_date transaction_to_date rate
DAY4 DAY1 DAY3 100.00
DAY6 --- -- 50.00
Require data format: