Home Forums SQL Server 2008 T-SQL (SS2K8) SQL /Procedure - for Transpose and Calculation RE: SQL /Procedure - for Transpose and Calculation
Mansfield
SSCrazy
Points: 2366
More actions
April 8, 2013 at 8:19 pm
#1604640
Use UNPIVOT to turn each PAYMENT_TYPE into its own column. See the following link.
Then your calculation should be easy 🙂