Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: dwilliams459
- Order by date
-
local variable dissapears
After posting I see that adding a brackets around the temp table resolves the syntax issue. For example the following will return results (assuming the Temp table "@Tags" exists as declared previously): select [@Tags].Tag From @Tags- dwilliams459
- Post #14
- Forum: Microsoft SQL Server: Programming
-
local variable dissapears
Similar situation, I am getting the same error: Must declare the scalar variable "@Tag" on the last line. I think I understand why the following fails, but how do I work around it? "select @Tags.tag" for example would not evaluate. In my case, I want to join to a temp table. How do I do...- dwilliams459
- Post #13
- Forum: Microsoft SQL Server: Programming
