Re: Stored Procedure question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 10:36:27 -0500

Maybe you could show the actual code, instead of two small pieces of it? 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"rob" <rwc1960@bellsouth.net> wrote in message 
news:XYX8c.146324$rB4.125337@bignews6.bellsouth.net...
> Within a stored procedure I am doing the follwing...
>
> insert into table1 select aa from #temp
>
> followed by
>
> insert into table2 select aa from table1
>
> The first insert is working fine, but the second on does not work at all.
> Funny thing though... if I cut and paste the second "insert into" into a
> separate stored procedure it works just fine
>
> Anyone know what is going on ?
>
>
>

Relevant Pages

  • Re: Convert MDB to ADP
    ... >> Your first sugestion I think is good for open forms adn reports can I use ... nearly as fast as a stored procedure in terms of ... >>> execution time. ... >>> Rob ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Stored procedure to drop and create table for end user
    ... >>> such) so the only thing the end user has access to is execute permission ... >>> back with select permission not granted on a table the stored procedure ... >> Probably because you are using dynamic SQL. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Assertion: SQL Server 2000 cant issue a SOAP call
    ... Calling it directly might not be supported, but there's no reason a remoting ... > It might be worth mentioning that calling CLR code from SQL Server is not ... > Tibor Karaszi, SQL Server MVP ... >> from a stored procedure, or from an extended stored procedure, but I ...
    (microsoft.public.sqlserver.programming)
  • Re: Createobject of (null) caused exception C0000005
    ... Aaron [SQL Server MVP] wrote: ... >> coming from my stored procedure. ... with more or less effort or performance impact in the database tier. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: 900 byte limit on stored procedure parameter?
    ... Please post the stored procedure and the full CREATE TABLE definition - ... SQL Server MVP ... http://sqlserverfaq.com - free video tutorials ... If I pass 901 characters I ...
    (comp.databases.ms-sqlserver)