General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Why no return value?
Hello Group
I am new at sql server.
I am trying to update a table and return the nextuniq number so that I can update my primary key table with the next avaialble primary key.
My question is why isn't this returning anything?
In my test with thequery analyzer i type in
execute sp_create_translator_table 451001830, 0
my stored procedure is:
CREATE PROCEDURE sp_create_translator
@Nextuniq int, @ReturnNextUniq int output
AS
/****** Object: Table [dbo].[translator] Script Date: 4/1/2002 9:13:23 AM ******/
if exists (select * from sysobjects where id = object_id(N'[dbo].[translator]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[translator]
DECLARE @Home_suniq int , @Ident varchar(10)
DECLARE translator_cursor CURSOR
DYNAMIC
FOR
SELECT
jw2.suniq AS home_suniq,
jw2.ident
FROM
dbo.jw2_studemo_suniq_ident as jw2
WHERE
NOT EXISTS (select * from dbo.catcboe_students where ident = jw2.ident)
OPEN translator_cursor
FETCH NEXT FROM translator_cursor INTO @Home_suniq, @Ident
While @@FETCH_STATUS = 0
BEGIN
INSERT INTO translator
( suniq, ident,oldsuniq )
VALUES
(@nextuniq, @Ident, @Home_suniq)
set @Nextuniq = @Nextuniq + 1
FETCH NEXT FROM translator_cursor INTO @Home_suniq, @Ident
END
SET @ReturnNextUniq = @Nextuniq
CLOSE translator_cursor
DEALLOCATE translator_cursor
I would like it to return the current value of @nextuniq to the calling program.
Thanks
Jim
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only