• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1116
  • Last Modified:

Incorrect syntax near the keyword 'DECLARE' in View

Msg 156, Level 15, State 1, Procedure v_SSRS_Get_CurrentMonthCollection_AZ, Line 9
Incorrect syntax near the keyword 'DECLARE'.
Msg 156, Level 15, State 1, Procedure v_SSRS_Get_CurrentMonthCollection_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_CurrentMonthCollection_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
0
dba123
Asked:
dba123
  • 3
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
I dont think you can declare local variables inside the view
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
this is the syntax of the view

CREATE VIEW [ < database_name > . ] [ < owner > . ] view_name [ ( column [ ,...n ] ) ]
[ WITH < view_attribute > [ ,...n ] ]
AS
select_statement
[ WITH CHECK OPTION ]
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Your code looks like a procedure, so better to  keep it as a procedure
0
 
dba123Author Commented:
ok, yea, maybe you're right....I could benefit from a view in my case but oh well....
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now