This is the table i have.... Op_date Dept Name Major Miner 5/20/2014 NEUROSURGERY 0 1 5/20/2014 UROLOGY 0 1 5/21/2014 ORTHOPEDICS 1 0 5/23/2014 UROLOGY 1 0 But i want to doing like this.. Op_date NEUROSURGERY UROLOGY ORTHOPEDICS Major Miner Major Miner Major Miner 5/20/2014 0 1 0 1 0 0 5/21/2014 0 0 0 0 1 0 5/23/2014 0 0 1 0 0 0 How we can doing this with PIVOT or other concept....
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip