Stored Procedure

desireemm · September 15th, 2004, 11:45 AM

I keep getting incorrect syntax with this statement can anyone tell me whats wrong says incorrect syntax must declare the variable

Code:

CREATE PROCEDURE [insert_Corovan_Table_1]
@pdBegin  DATETIME =  TerminationDate (BETWEEN CONVERT(DATETIME, '2003-01-01 00:00:00', 102) AND CONVERT(DATETIME, '2003-12-31 00:00:00', 102))
@pdEnd    DATETIME=   NULL
AS
IF @pdBegin IS NULL
   SET @pdBegin = DateAdd(year, -2, GetDate())
IF @pdEnd IS NULL
   SET @pdEnd = DateAdd(year, 1,@pdBegin)

AS INSERT INTO [GamingCommissiondb].[dbo].[Corovan_Table] 
     ( [TM #],
     [FirstName],
     [LastName],
     [SS #],
     [TerminationDate],
     [Voluntary or Involuntary],
     [Notes]) 
SELECT   ([TM#],     
     [FirstName],    
     [LastName],     
     [SS #],     
     [TerminationDate],     
     [Voluntary_or_Involuntary],
     [Notes],)
FROM TERMINATION 
GO

bmains · September 15th, 2004, 02:08 PM

Hey,

What database is that? Is that SQL Server?

Brian

joefawcett · September 16th, 2004, 02:01 AM

I don't quite understand the part where you declare the input parameters but normally you need to separate them by commas.

--

Joe

happygv · September 16th, 2004, 02:09 AM

Also I see you using 2 ASs in there, which should have exisited only once for a proc.

Code:

AS
IF @pdBegin IS NULL
...
...
AS INSERT INTO

Cheers!

_________________________
- Vijay G
Strive for Perfection

cs8271506 · September 17th, 2004, 07:04 PM

I think that last comma

[Notes],)

shouldn't be there.

-- conrad

happygv · September 18th, 2004, 02:34 AM

Yes you are right conrad, I somehow left that unnoticed.

desireemm,
Now the suggestions from the previous 3 posts(joe's, mine and conrad's all that are responsible for syntax errors) would have helped you out.

_________________________
- Vijay G
Strive for Perfection