dba123
asked on
Incorrect syntax near the keyword 'DECLARE' in View
Msg 156, Level 15, State 1, Procedure v_SSRS_Get_CurrentMonthCol lection_AZ , Line 9
Incorrect syntax near the keyword 'DECLARE'.
Msg 156, Level 15, State 1, Procedure v_SSRS_Get_CurrentMonthCol lection_AZ , Line 23
Incorrect syntax near the keyword 'AS'.
I have no clue why it's complaining unless I can't use params here:
CREATE VIEW [dbo].[v_SSRS_Get_CurrentM onthCollec tion_AZ]
AS
BEGIN
DECLARE @today datetime,
@datefirst datetime,
@Posted money,
@GrossGoal money,
@OldPDCs money,
@NewPDCs money,
@OldCCs money,
@NewCCs money,
@InHouse1 money,
@InHouse2 money,
@Var1 money,
@DailyRunRate money,
@ProjGross money,
@ProjFee money
SET @today = DATEADD(d, -5, CONVERT(CHAR(8), GETDATE(), 112)) --'Jun 26 2005'
SET @datefirst = @@DATEFIRST
Incorrect syntax near the keyword 'DECLARE'.
Msg 156, Level 15, State 1, Procedure v_SSRS_Get_CurrentMonthCol
Incorrect syntax near the keyword 'AS'.
I have no clue why it's complaining unless I can't use params here:
CREATE VIEW [dbo].[v_SSRS_Get_CurrentM
AS
BEGIN
DECLARE @today datetime,
@datefirst datetime,
@Posted money,
@GrossGoal money,
@OldPDCs money,
@NewPDCs money,
@OldCCs money,
@NewCCs money,
@InHouse1 money,
@InHouse2 money,
@Var1 money,
@DailyRunRate money,
@ProjGross money,
@ProjFee money
SET @today = DATEADD(d, -5, CONVERT(CHAR(8), GETDATE(), 112)) --'Jun 26 2005'
SET @datefirst = @@DATEFIRST
I dont think you can declare local variables inside the view
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Your code looks like a procedure, so better to keep it as a procedure
ASKER
ok, yea, maybe you're right....I could benefit from a view in my case but oh well....