sp help -error on sp

• Frances L

  SSCarpal Tunnel

  Points: 4727

  More actions

  July 7, 2009 at 1:00 pm

  #136280

  CREATE PROCEDURE [dbo].[GetChestTube]

  @DateFrom datetime='09/04/05',

  @DateToIn datetime='03/04/06',

  @cc varchar(50)

  with recompile

  AS

  SET NOCOUNT ON

  begin

  declare @DateTo datetime

  select @DateTo = @DateToIn+1

  SELECT distinct h.[FULL NAME], h.[DOB], h.CC

  FROM annual_edu_2006.dbo.HREMP h WHERE h.HREMP.CC=@CC inner JOIN

  (SELECT [Employee Name],DOB

  FROM [NursingFeedBack] where [Submit Time] >= @DateFrom and [Submit Time] <= @DateTo )
  [b]x [/b]ON h.[Full Name]=x.[Employee Name] and h.[DOB]=x.[DOB]

  I do not know why I get this error:

  Msg 156, Level 15, State 1, Procedure GetChestTube, Line 17
  Incorrect syntax near the keyword 'inner'.
  Msg 170, Level 15, State 1, Procedure GetChestTube, Line 20
  Line 20: Incorrect syntax near 'x'.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  July 7, 2009 at 1:06 pm

  #1021289

  Your format is wrong.

  select a

  from tableA

  inner join Table B

  on a.x = b.x

  WHERE a.y = 1

  The joins come before the WHERE.