hi i was stuck in the similar situation and following code works for me...

Server: Sql Server 2005

Query :

select top 1 name into #tmp from sysobjects

declare @result varchar(50)

select @result=name...