I have table like the below and want to see in Matrix table. I know this could be achieved thro Pivot, not sure how to query please help.
doesnot matter if we can do it in SSMS or in SSIS.
Mobile Calldate Dispo
234 20-2-2011 CB
235 21-2-2011 PTP
Mobile 20-2-2011 21-02-2011 22-2-2011 ...
234 CB null null
235 null ptp null