Pivot_method, Sql Server

Language: Layout:

CREATE TABLE [sales](
	[CSSTOR] [numeric](5, 0) NOT NULL,
	[TOTAL_PRICE] [numeric](38, 3) NULL,
	[Margin] [numeric](38, 6) NULL,
	[TOTAL_Profit] [numeric](38, 3) NULL,
	[Total_COST] [numeric](38, 4) NULL
) ON [PRIMARY]

INSERT INTO [sales] VALUES(50036,	25131.250,	12.876400	,3236.008	,21895.2421)
INSERT INTO [sales] VALUES(50026,	87732.470,	13.901600	,12196.269	,75536.2006)
INSERT INTO [sales] VALUES(50006,	77530.620,	13.841900	,10731.743	,66798.8770)
INSERT INTO [sales] VALUES(50017,	40097.190,	11.662900	,4676.506	,35420.6844)
INSERT INTO [sales] VALUES(50047,	45848.710,	14.268400	,6541.888	,39306.8219)
INSERT INTO [sales] VALUES(50037,	17029.810,	13.829900	,2355.212	,14674.5980)
INSERT INTO [sales] VALUES(50027,	75493.600,	14.490900	,10939.739	,64553.8611)
INSERT INTO [sales] VALUES(50007,	27153.030,	11.803900	,3205.127	,23947.9030)
INSERT INTO [sales] VALUES(50048,	46728.060,	12.531400	,5855.688	,40872.3721)
INSERT INTO [sales] VALUES(50028,	30872.940,	13.028200	,4022.209	,26850.7310)
INSERT INTO [sales] VALUES(50008,	61974.180,	13.886100	,8605.854	,53368.3260)
INSERT INTO [sales] VALUES(50038,	17190.610,	12.486200	,2146.463	,15044.1469)
INSERT INTO [sales] VALUES(50039,	48018.250,	5.346900	,2567.526	,45450.7237)
INSERT INTO [sales] VALUES(50049,	35941.500,	11.092800	,3986.927	,31954.5728)
INSERT INTO [sales] VALUES(50029,	44106.940,	13.131800	,5792.052	,38314.8880)
INSERT INTO [sales] VALUES(50019,	39339.940,	14.160600	,5570.799	,33769.1408)
INSERT INTO [sales] VALUES(50040,	40693.330,	12.369900	,5033.752	,35659.5784)
INSERT INTO [sales] VALUES(50030,	53085.970,	12.046700	,6395.124	,46690.8460)
INSERT INTO [sales] VALUES(50020,	61528.750,	13.056700	,8033.643	,53495.1072)
INSERT INTO [sales] VALUES(50010,	40194.330,	12.991800	,5222.006	,34972.3242)
INSERT INTO [sales] VALUES(50041,	40097.640,	12.226900	,4902.718	,35194.9217)
INSERT INTO [sales] VALUES(50031,	77884.530,	9.238900	,7195.694	,70688.8360)
INSERT INTO [sales] VALUES(50021,	90946.760,	12.355500	,11236.982	,79709.7779)
INSERT INTO [sales] VALUES(50001,	39498.300,	12.562300	,4961.932	,34536.3675)
INSERT INTO [sales] VALUES(50042,	64223.200,	13.290500	,8535.633	,55687.5668)
INSERT INTO [sales] VALUES(50032,	39490.130,	14.726000	,5815.355	,33674.7753)
INSERT INTO [sales] VALUES(50022,	66602.810,	12.567800	,8370.569	,58232.2408)
INSERT INTO [sales] VALUES(50012,	31329.510,	14.151300	,4433.557	,26895.9526)
INSERT INTO [sales] VALUES(50002,	31647.150,	11.159300	,3531.624	,28115.5264)
INSERT INTO [sales] VALUES(50043,	55461.870,	13.161100	,7299.393	,48162.4773)
INSERT INTO [sales] VALUES(50033,	35486.720,	8.224400	,2918.604	,32568.1158)
INSERT INTO [sales] VALUES(50023,	70549.250,	12.387900	,8739.596	,61809.6541)
INSERT INTO [sales] VALUES(50013,	35080.480,	13.330000	,4676.263	,30404.2168)
INSERT INTO [sales] VALUES(50003,	39691.180,	11.286800	,4479.868	,35211.3115)
INSERT INTO [sales] VALUES(50044,	33908.310,	11.479500	,3892.531	,30015.7794)
INSERT INTO [sales] VALUES(50034,	17208.780,	8.398300	,1445.262	,15763.5180)
INSERT INTO [sales] VALUES(50024,	37125.040,	10.122100	,3757.867	,33367.1726)
INSERT INTO [sales] VALUES(50014,	51475.620,	12.559800	,6465.278	,45010.3422)
INSERT INTO [sales] VALUES(50004,	67062.810,	13.691500	,9181.943	,57880.8672)
INSERT INTO [sales] VALUES(50045,	38778.360,	11.264400	,4368.184	,34410.1756)
INSERT INTO [sales] VALUES(50035,	19578.640,	10.538400	,2063.281	,17515.3589)
INSERT INTO [sales] VALUES(50025,	58158.960,	13.853000	,8056.790	,50102.1700)
INSERT INTO [sales] VALUES(50015,	34844.170,	8.108700	,2825.443	,32018.7270)
INSERT INTO [sales] VALUES(50005,	32089.110,	13.341200	,4281.103	,27808.0067)

go
    
select * from 
    (
    select rtrim(cast(csstor as char))+' Sales' as s
            ,rtrim(cast(csstor as char))+' margin' as m
            ,rtrim(cast(csstor as char))+' profit' as p
            ,rtrim(cast(csstor as char))+' cost' as c
            ,[TOTAL_PRICE]
            ,[Margin] 
            ,[TOTAL_Profit] 	
            ,[Total_COST]
    from sales
    
    ) as result_1
pivot (sum(total_price)		for s in ([50001 Sales],[50002 Sales])) as pv_tb 
pivot (sum(Margin)			for m in ([50001 margin],[50002 margin])) as pv_tb1
pivot (sum(total_profit)	for p in ([50001 profit],[50002 profit])) as pv_tb2
pivot (sum(total_cost)		for c in ([50001 cost],[50002 cost])) as pv_tb3

group by [50001 cost],[50001 margin],[50001 profit],[50002 cost],[50002 margin],[50002 profit],[50001 sales],[50002 sales]

View schema
Execution time: 0,05 sec, rows selected: 3, rows affected: 44, absolute service time: 0,23 sec, absolute service time: 0,23 sec