Help Passing Table Name as Stored Proc Parameter

• bshulam

  SSC-Addicted

  Points: 406

  More actions

  December 26, 2007 at 9:59 am

  #182256

  I created the following Stored Procedure however when I try to Exec and pass a value for the table name it says Invalid Object Name '@CheckTable'

  Msg 208, Level 16, State 1, Procedure Invalid object name '@CheckTable'.

  Exec sp_vcGetStop 'CHECKS_DEC2007','3300000001'

  CREATE PROCEDURE [dbo].[sp_vcGetStop]

  @CheckTablevarchar(15),

  @Sequence numeric(10,0)

  AS

  BEGIN

  SELECT CUID As 'Rt', WorkType

  FROM [@CheckTable]

  WHERE Sequence = @Sequence

  END

• Dave-3000

  SSCertifiable

  Points: 6186

  More actions

  December 26, 2007 at 11:51 am

  #762763

  It doesn't work like that. Google "dynamic sql" and sp_executesql or look it up in BOL.

  There is no "i" in team, but idiot has two.

• bshulam

  SSC-Addicted

  Points: 406

  More actions

  December 26, 2007 at 12:34 pm

  #762775

  Thanks issue resolved.