移调(也许)行至列
问题描述:
Employee Entity Payor Location PROC_QTY Work_RVUs CHARGES PAYMENTS REFUNDS UPL_DISTRIBUTION
No Employee 29040100 BCBS - FSC1 Inpatient 679.5 3.45 84423.5 14514.85 0 0
我需要的方式对上述转换为以下SQL Server Management Studio中:移调(也许)行至列
Employee Entity Payor Location Account Amount
No Employee 29040100 BCBS - FSC1 Inpatient PROC_QTY 679.5
No Employee 29040100 BCBS - FSC1 Inpatient Work_RVUs 3.45
No Employee 29040100 BCBS - FSC1 Inpatient CHARGES 84423.5
No Employee 29040100 BCBS - FSC1 Inpatient PAYMENTS 14514.85
No Employee 29040100 BCBS - FSC1 Inpatient REFUNDS 0
No Employee 29040100 BCBS - FSC1 Inpatient UPL_DISTRIBUTION 0
谢谢!完美工作。 – MikeW 2014-10-20 20:27:37