View Single Post

   
  #9 (permalink)  
Old 03-04-2008, 07:23 AM
Vic
 
Posts: n/a
Default Re: help with stored procedure which returns an OUTPUT value

On Mar 3, 2:22 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Vic (vikra...@gmail.com) writes:
> > I finally got it working. Thanks a million. Btw as you mentioned 'I
> > strongly recommend that you set your newsreader to show posts with a
> > fixed font'. I just read my group mails by loggin onto google groups.
> > I'll take a look to change the settings. Thanks

>
> I seem to recall that Google has a setting to show posts in fixed fonts.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


i see. I'll check it out. Thanks. I have one more question regarding
the same issue. Is there anyway I can store the output of the above
mentioned sp_executesql into a sql variable ? or can I create a
temporary table #temp and do insert #temp
sp_executesql @sql, @params,@objectclass,@fieldnumber,@columnname
OUTPUT and do select * on it to return the value?
Reply With Quote