| Malcolm Cook 2005-04-06, 8:06 pm |
| try putting a 'set nocount on' at the begininning of your stored proc (c.f.
http://msdn.microsoft.com/library/d...html/vb01a1.asp)
let us know.
--
Malcolm Cook - mec@stowers-institute.org
Database Applications Manager - Bioinformatics
Stowers Institute for Medical Research - Kansas City, MO USA
"Jeff Davies" <ng1@techyremovethis.com.au> wrote in message
news:%23DdbRE%23FFHA
.3888@TK2MSFTNGP12.phx.gbl...
> Guys,
> I am trying to Execute the following in a stored proc.
>
> exec spCreateTmpTable @Param1, @Param2
>
> SELECT TOP 100 PERCENT dbo.tblCustomers.*
> FROM dbo.tblCustomers INNER JOIN
> dbo.TmpTable ON dbo.tblCustomers.ID = dbo.TmpTable.ID
>
>
> These two things work fine individually.
> spCreateTmpTable creates the Temp Table and fills it with appropriate
data.
>
> The Select SQL will then happily work in a view,
> but when I try and run them both in the one SP, I get no records returned.
> What am I missing?
> Thanks in advance,
> Jeff
>
>
>
|