Unknown symbol: #

21 Jul 2006 10:39 PM

KTN

I found this in a old stored procedure and wonder if anyone has seen it
before? I check BOL and could not find any explanation. Thanks!

select columnA
from TableABC
where ColumnB = @Val1 and ColumnC = #Breakout.Col1

what is the # symbol means?

21 Jul 2006 10:55 PM

ML

Temporary object names start with # for temporary objects local to a
connection or ## for global temporary objects.

E.g. a temporary table:

create table #temp
(
FirstName varchar(32)
,LastName varchar(32)
)
go

Have you posted the entire query?

ML

---
http://milambda.blogspot.com/

21 Jul 2006 10:59 PM

Arnie Rowland

The '#' indicates a Temp table. It is still in common use.

Look somewhere previous to this location in the same stored procedure and
you will find a statement like:

CREATE TABLE #Breakout

--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"KTN" <K**@discussions.microsoft.com> wrote in message
news:FDF469F5-605E-4415-826F-02FF1E262996@microsoft.com...
>I found this in a old stored procedure and wonder if anyone has seen it
> before? I check BOL and could not find any explanation. Thanks!
>
> select columnA
> from TableABC
> where ColumnB = @Val1 and ColumnC = #Breakout.Col1
>
> what is the # symbol means?