David McAfee
davidmcafee at gmail.com
Wed Apr 3 12:14:45 CDT 2013
Have any of you come across this error? I am running a local instance of SQL 2012 on my box. I created a few tables and I am now creating a stored procedure. In the procedure, I get a red underline under one of the table names. When I mouse over the red underline, it displays: "Invalid object name 'tblTerritoryRsmJunct'" The select statement DOES work and return the correct values. SELECT R.RegionDesc, GSM.Fullname AS GSM, RSM.Fullname AS RSM, T.Territory, T.TerrID AS TerritoryID FROM tblRegion R (NOLOCK) INNER JOIN tblUser GSM (NOLOCK) ON R.GsmUserGuid = GSM.UserGuid INNER JOIN tblTerritory T (NOLOCK) ON T.RegionID = R.RegionID INNER JOIN (SELECT TerritoryID, MAX(entryDate) as MaxDate FROM tblTerritoryRsmJunct (NOLOCK) WHERE entryDate < @AsOfDate GROUP BY TerritoryID) AS RJ1 ON T.TerrID = RJ1.territoryid INNER JOIN tblRouteSellerJunct AS RJ2 (NOLOCK) ON RJ1.territoryID = RJ2.TerritoryID AND RJ1.MaxDate = RJ2.entryDate INNER JOIN tblUser RSM (NOLOCK) ON RSM.UserGuid = RJ2.RsmGuid I've even dragged in the table name from the Object explorer so it reads: [dbo].[tblRouteSellerJunct] but it still underlines it in red. The file name is 20 characters long. I've named tables with longer names before. Any ideas? Thanks, David