我们如何以下列方式显示数据..... [英] How we can show Data into following manner.....

问题描述

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....

推荐答案

本文对

This article may be useful Pivot two or more columns in SQL Server 2005[^]. The same methodology works in later versions of SQL Server.

这篇关于我们如何以下列方式显示数据.....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！