SQL show monh to date numbers

SELECT [Performance].[Date] As [Date],
	[Performance].[Shaft],
	SUM([Performance].[Drilled Total]) AS Metres,
	[vShafts_StartDate].[Target] * Count(DISTINCT [Performance].[Date]) As Target,
	AVG([Performance].[Drilled Total]) As [Ave M/Mach/Shift],
	SUM([Performance].[Delay Hours 1]) AS Delays,
	SUM([Performance].[DWR Hours]) AS DWR,
	SUM([Performance].[Standing Time]) AS [Standing Time],
	SUM([Performance].[Grout Hours]) AS [Grout Hours],
	SUM([Performance].[Concrete Redrill]) AS ReDrill,
	SUM([Performance].Setup) AS Setups,
	SUM([Performance].[Transport Hours]) as [Transport Hours],
	SUM([Performance].[Photographic Survey]) as [Photographic Survey],
	SUM([Performance].[Day Rate]) as [Day Rate],
	SUM([Performance].[Blank Cap]) as [Blank Cap],
	SUM([Performance].[Mobilise]) as [Mobilise],
	SUM([Performance].[Set Up Stope]) as [Set Up Stope],
	SUM([Performance].[Interhole Move]) as [Interhole Move],
	SUM([Performance].[Grouting Borehole]) as [Grouting Borehole],
	SUM([Performance].[Plugging]) as [Plugging],
	SUM([Performance].[Trp Equip UG]) as [Trp Equip UG],
	CAST([vShafts_StartDate].[StartDate] As Date) As [Month_Start],
	[vShafts_StartDate].[Target] as newTarget,
	SUM(CASE WHEN YEAR([Performance].[Date]) = YEAR(GETDATE()) AND MONTH([Performance].[Date]) = MONTH(GETDATE()) THEN [Performance].[Drilled Total] ELSE 0 END) AS MTDDrillTodal
FROM [Performance]
INNER JOIN [vShafts_StartDate]
	ON [Performance].[Shaft] = [vShafts_StartDate].[Shaft]
WHERE [Performance].[Date] >= [vShafts_StartDate].[StartDate]
	AND [Performance].[Date] <= CAST(GETDATE() AS DATE)
	AND [Performance].[Shaft] = 'kopanang air'
GROUP BY [Performance].[Date], [Performance].Shaft, [vShafts_StartDate].[StartDate], [vShafts_StartDate].[Target]

Select allOpen in new window