karthik82.vk (7/2/2015)
Hi J,The reply I got from the Stackoverflow forum helped me to get the solution but not the answer for my scenario. In the answer I got Tanner has included a column but in my situation I cannot have a id column as i will be having incremental data which keeps on updating and changing.
So What I did is I used the ROW_NUMBER OVER ORDER BY instead of the id column and created a view that will help me to change the dates based on the time.
Then I used that view with my few other tables to get some values pivoted and got the solution.
Anyhow the reply of Tanner has helped me solved the issue.
Thanks again to Tanner.
kudos to you for your response......will be appreciated I am sure
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day