Invalid object name dbo.tblStore s

• yogiberr

  Hall of Fame

  Points: 3679

  More actions

  May 27, 2004 at 8:03 am

  #107888

  Hi,

  I've written a sproc in sql2k, and I keep getting this error.I am sure that it is something really simple.Can anyone help?

  <code>

  CREATE PROCEDURE [dbo].[spStoreContactDexGet]

  @storeId int

  AS

  SELECT

   [s.storeId],

   [s.storeName]

  FROM

   [dbo].[tblStore s]

  <\code>

  I have an inner join in this query, But even after I remove the inner join, I still get the error.

  Can anyone help?

  ta,

  yogi

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  May 27, 2004 at 9:00 am

  #508031

  is "tblstore s" the name of the table or are you trying to create an alias for it? If an alias move the S outside the bracket and try again.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• yogiberr

  Hall of Fame

  Points: 3679

  More actions

  May 27, 2004 at 9:12 am

  #508038

  It was an alias.Thanks Nicholas.That worked.

  here's the code for anyone who's interested in the solution:

  <code>

  SELECT

  s.[storeId],

  s.[storeName]

  FROM

   [dbo].[tblStore  ] s

  <\code>

  cheers,

  yogi