My "FeedbackSummary" table structure is
GivenBy varchar(50)
GivenTo varchar(50)
Points decimal(15, 2)
Sample Data
Alice Janet 4.50
Alice Bruce 3.50
Bruce Alice 2.87
Bruce Janet 4.75
Janet Alice 5.45
Janet Bruce 3.78
What I am trying to achieve
GivenBy_GivenTo Alice Bruce Janet
Alice NULL 3.50 4.50
Bruce 2.87 NULL 4.75
Janet 5.45 3.78 NULL
Platform: SQL Server 2005 & 2008
How this can be done using Pivot or any other techniques. Can this be achieved using SQL Reporting Services easily?
Thanks in advance.