select POWER(convert(bigint,2),31) as val into #temp
he was referencing another thread, where someone asked for the max size of a varchar(max);
that thread is here:
http://www.sqlservercentral.com/Forums/Topic1470699-391-1.aspx
i reused my same code example from that thread, but inserted it into a #temp table to show you how to use a temp table;
he was referring to the fact that he noticed the same code in the other thread.
it was just a for-fun notification that he sees everything.
Lowell