[thelist] resolution to : calling sql stored proc using asp

[Ken Schaefer]

So, are you saying that you reference a #temp table in your sproc that
you created using another sproc?

Looking over your original post, there didn't seem to be any
indication that this is what you were doing...

Cheers
Ken


On Wed, 13 Oct 2004 10:57:04 -0400, Brian Delaney
<brian.delaney at mccmh.net> wrote:
> The problem is that if you use a #temp table it is not accessible
> outside the running proc. I created a regular table called temp1 and
> inserted a routine that creates and drops the table before/during the
> next data upload.
> 
> I changed the SP to just return the records from temp1.
> 
> Thanks to all that helped.