CREATE TABLE #DonationsThisYear
(Solicitor nvarchar(8), SumPayment bigint, CountPayment int)
INSERT INTO  #DonationsThisYear

	SELECT
		FamilyDonationHistory.Solicitor AS Solicitor,
		SUM(FamilyDonationHistory.PaymentAmt) AS SumPayment,
		COUNT(FamilyDonationHistory.PaymentAmt) AS CountPayment
	FROM 
		FamilyDonationHistory 
	WHERE 
		(DepositDate < @today) 
		AND ((right(Event, 2)) = right(@year, 2))
		AND (left(Event, 2) <> 'TR')
	GROUP BY
		Solicitor,
		SumPayment,
		CountPayment

Server: Msg 207, Level 16, State 3, Line 3
Invalid column name 'SumPayment'.
Server: Msg 207, Level 16, State 1, Line 3
Invalid column name 'CountPayment'.
Server: Msg 207, Level 16, State 1, Line 3
Invalid column name 'SumPayment'.
Server: Msg 207, Level 16, State 1, Line 3
Invalid column name 'CountPayment'.

CREATE TABLE	#DonationsThisYear
		(
			Solicitor nvarchar(8),
			SumPayment bigint,
			CountPayment int
		)

INSERT INTO	#DonationsThisYear
		(
			Solicitor,
			SumPayment
			CountPayment
		)
SELECT		Solicitor,
		SUM(PaymentAmt) AS SumPayment,
		COUNT(PaymentAmt) AS CountPayment
FROM		FamilyDonationHistory 
WHERE		DepositDate < @Today
		AND RIGHT(Event, 2)) = RIGHT(@Year, 2)
		AND LEFT(Event, 2) <> 'TR'
GROUP BY	Solicitor