Check the bold.
DECLARE @Months TABLE
(
NewDate DATETIME,
AuditTotal BIGINT,
Grand_Total varchar(50)
)
Insert Into @Months Values(@CurrentDate,@AuditTotal,@Grand_Total)
select convert( varchar(50), NewDate, 103 ) as 'NewDate',AuditTotal AS 'Total Audited',Grand_Total FROM @Months