Re: recordset from a temp table /ty (resolved)

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

From: tushar (tgkprog6_at_hotmail.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 09:33:54 -0800

hi thanks a TON
- i tried putting SET NOCOUNT ON before the stored proc (
where we put options like SET QUOTED_IDENTIFIER OFF )- but
then realized need too put it in the actual defination

ALTER PROCEDURE aSp_ListMissingJobs AS
Declare @PID int
Declare @EndTo int
Declare @ActualEnd int
Declare @StartFrom int

Declare @SearchJob int
Declare @I int
declare @exStr varchar(200)
Begin
        SET NOCOUNT ON
        Create Table #Pending(Pen_ID integer,Pen_Job
integer)

---etc...

Relevant Pages