Incorrect Syntax near AS

Can anyone see why I would get the 'Incorrect Syntax near AS' error in this?

USE [SQL2]
GO
/****** Object: StoredProcedure [dbo].[PlanGroupGrid] Script Date: 06/18/2007 06:07:34 ******/
SET ANSI_NULLSON
GO
SET QUOTED_IDENTIFIERON
GO

ALTER PROCEDURE [dbo].[PlanGroupGrid]
@.dp_idint
AS

SELECT tblExpenses.gp_ID, tblExpenses.AmountINTO #tempApExp
FROM tblExpenses

SELECT tblGroups.dp_id, tblGroups.Group_ID, tblGroups.Group_Type, tblGroups.Group_Purpose,
tblGroups.Group_StartDate, tblGroups.Group_EndDate,COALESCE (tblGroups.Group_Goal, 0)AS Goal,
SUM(COALESCE(#tempApExp.Amount,0))AS [Total Expenses],SUM(COALESCE (tblReceipts.AmountPaid, 0))AS [Total Paid],
SUM(COALESCE (tblReceipts.AmountPaid, 0)) -COALESCE (tblGroups.Group_Goal, 0) -SUM(COALESCE(#tempApExp.Amount,0))AS [Total Expenses],
AS Variance
FROM tblGroupsLEFTOUTER JOIN
tblTrackingON tblGroups.Group_ID = tblTracking.Group_IDLEFTOUTER JOIN
tblReceiptsON tblTracking.gp_ID = tblReceipts.gp_IDLEFTOUTER JOIN
#tempApExpON tblTracking.gp_ID = #tempApExp.gp_ID
WHERE (tblGroups.dp_id = @.dp_id)
GROUP BY tblGroups.dp_id, tblGroups.Group_ID, tblGroups.Group_Type, tblGroups.Group_Purpose,
tblGroups.Group_StartDate, tblGroups.Group_EndDate, tblGroups.Group_Goal

IfExists (select *from dbo.sysobjectswhere id =object_id(N'[dbo].[tempApExp]')andOBJECTPROPERTY(id,N'IsUserTable') = 1)
Drop table #tempApExp

You need parentheses around your parameter.

ALTER PROCEDURE [dbo].[PlanGroupGrid](@.dp_idint)AS

|||

Jackxxx:

Can anyone see why I would get the 'Incorrect Syntax near AS' error in this?

USE [SQL2]
GO
/****** Object: StoredProcedure [dbo].[PlanGroupGrid] Script Date: 06/18/2007 06:07:34 ******/
SET ANSI_NULLSON
GO
SET QUOTED_IDENTIFIERON
GO

ALTER PROCEDURE [dbo].[PlanGroupGrid]
@.dp_idint
AS

SELECT tblExpenses.gp_ID, tblExpenses.AmountINTO #tempApExp
FROM tblExpenses

SELECT tblGroups.dp_id, tblGroups.Group_ID, tblGroups.Group_Type, tblGroups.Group_Purpose,
tblGroups.Group_StartDate, tblGroups.Group_EndDate,COALESCE (tblGroups.Group_Goal, 0)AS Goal,
SUM(COALESCE(#tempApExp.Amount,0))AS [Total Expenses],SUM(COALESCE (tblReceipts.AmountPaid, 0))AS [Total Paid],
SUM(COALESCE (tblReceipts.AmountPaid, 0)) -COALESCE (tblGroups.Group_Goal, 0) -SUM(COALESCE(#tempApExp.Amount,0))AS [Total Expenses],
AS Variance
FROM tblGroupsLEFTOUTER JOIN
tblTrackingON tblGroups.Group_ID = tblTracking.Group_IDLEFTOUTER JOIN
tblReceiptsON tblTracking.gp_ID = tblReceipts.gp_IDLEFTOUTER JOIN
#tempApExpON tblTracking.gp_ID = #tempApExp.gp_ID
WHERE (tblGroups.dp_id = @.dp_id)
GROUP BY tblGroups.dp_id, tblGroups.Group_ID, tblGroups.Group_Type, tblGroups.Group_Purpose,
tblGroups.Group_StartDate, tblGroups.Group_EndDate, tblGroups.Group_Goal

IfExists (select *from dbo.sysobjectswhere id =object_id(N'[dbo].[tempApExp]')andOBJECTPROPERTY(id,N'IsUserTable') = 1)
Drop table #tempApExp

You have 'As Variance ' after your declaration of 'AS [Total Expenses]'