using Declare in Stored Procedure

[AgentM]

Hi,
I am new to T-SQL and I am trying to use "declare" in a stored procedure. I am getting a syntax error not sure why, any help appreciated. Here's the code :-

ALTER PROCEDURE [dbo].[TOTALCOUNT] 
	@StartDate  DateTime,
    @EndDate	DateTime
AS
BEGIN
 SET NOCOUNT ON;
 DEclare @TOTALPEOPLE int, @TOTALMEN int
 SET @TOTALPEOPLE = 10000
 
  SELECT col1, @TOTALPEOPLE, @TOTALMENFROM TABLE1

END

 

[bborissov]

The error is not on DECLARE it in query row:
This:

 SELECT col1, @TOTALPEOPLE, @TOTALMENFROM TABLE1

should be

 SELECT col1, @TOTALPEOPLE, @TOTALMENFROM [COLOR=red][b]FROM[/b][/color] TABLE1

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[bborissov]

O, I forgot:
You should be very sure that TABLE1 exists in your current database where you create that SP.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[AgentM]

the FROM was a typo.
I am getting a syntax error on line above the "SET NOCOUNT ON" line

 

[AgentM]

Never mind got it. The error was a space in the var name in the Declare.
Thank you

 

[bborissov]

And I just saw that your FROM is there

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.