BEGIN
	SET NOCOUNT ON;

	Select	
			t.sml,
			round(100.0 * t.SVU /case 
										when ( t.SVU + t.LVU ) = null then 1.0
										when ( t.SVU + t.LVU ) = 0 then 1.0
										else  t.SVU + t.LVU
									 end, 1) as SVUPercent,
			round(100.0 * t.LVU/ case 
										when t.SVU + t.LVU = null then 1.0
										when t.SVU + t.LVU = 0 then 1.0
										else t.SVU + t.LVU
									end,1) as LVUPercent,		
			round(100.0 * t.VU /	case 
										when Sum(t.VU) over () = null then 1.0
										when Sum(t.VU) over () = 0 then 1.0
										else Sum(t.VU) over ()  
									end,1) as VUPercent,
			round(100.0 * t.TTR / case
										when Sum(t.TTR) over () = null then 1.0
										when Sum(t.TTR) over () = 1 then 1.0
										else Sum(t.TTR) over ()
									end,1) as TTRPercent		
	from
	(
		SELECT			
				s.sml,		
				SUM(
					case when t.CMD = 0 then
								CASE WHEN s.MMode = 0 THEN ( s.CS / s.MD )
									 WHEN s.MMode = 1 THEN ( s.CS * t.[OP] / s.MD )
									 WHEN s.MMode = 2 THEN ( s.MI / s.MD )
								END * ( t.VOL / 100.0 ) * ps.RT
						  else 0.0	
					end
				 ) AS LVU,
				 
				SUM(
					case when t.CMD = 1 then
								CASE WHEN s.MMode = 0 THEN ( s.CS / s.MD )
									 WHEN s.MMode = 1 THEN ( s.CS * t.[OP] / s.MD )
									 WHEN s.MMode = 2 THEN ( s.MI / s.MD )
								END * ( t.VOL / 100.0 ) * ps.RT
						  else 0.0	
					end
				 ) AS SVU,
				 
				SUM(
					CASE WHEN s.MMode = 0 THEN ( s.CS / s.MD )
						 WHEN s.MMode = 1 THEN ( s.CS * t.[OP] / s.MD )
						 WHEN s.MMode = 2 THEN ( s.MI / s.MD )
					END * ( t.VOL / 100.0 ) * ps.RT
				 ) AS VU,		
				 	 
				 COUNT(t.t_id) as Total_T	
				 			 						        
		FROM [dbo].[view_user] u (NOLOCK)
		JOIN [dbo].[table_records] t (NOLOCK)
			  ON [t].[U_FID] = [u].[U_ID]
		JOIN [dbo].[table_cs] s (NOLOCK)
			  ON [s].[sym_ID] = [t].[sym_FID]
		LEFT JOIN [dbo].[view_PR] ps (NOLOCK)
			  ON [ps].[Sym] = [s].[MAC] + 'AAA'
		AND [ps].[Date] = CAST([t].[OTime] AS DATE)	                
		WHERE  
			[t].[CMD] IN (0, 1)
			AND t.CTime = '1970-01-01'
			AND s.MD > 0
		group by s.sml   
	)t	
	OPTION ( OPTIMIZE FOR UNKNOWN )
END