Strored procedure

Question

In SP select statement should return 6 vaues. i am facing issue like SP retured single value that is with out complete excution of SP

Laxmidhar Sahoo · Answer

Hi Yes Without out parameter .at fast fire select ststement like I define in the previous post

Laxmidhar Sahoo · Answer

hi Do not use + and ',' only use ,(comma) .like SELECT [dbo].fngetJOBID(@JOBIDSEQ) , @TCN , [dbo].[fngetFormName](@CARRIERID), 'NNNNNN', @CARRIERID , ',PROD' Define the function [dbo].[fngetFormName] with a string parameter nd return should be a string(varchar(200))

Vishvjit Shinde · Answer

One Way is Return the Values in Comma Separated in the single output variable. 2nd Way is take 6 output variables Using OUTPUT Keyword Eg: CREATE PROCEDURE ProcedureName ( @param1 int OUTPUT @param1 int OUTPUT .. ) AS

Sirisha K · Answer

Is there any chance to come out of the SP with complete execution.

Laxmidhar Sahoo · Answer

hi There are two ways.One is define 6 output paramater anad at last set the values to the parameter, Another set the values and at last select these like SELECT [dbo].fngetJOBID(@JOBIDSEQ) , @TCN , [dbo].[fngetFormName](@CARRIERID) + 'NNNNNN' , @CARRIERID ,'PROD'

Sirisha K · Answer

declare @CARRIERID VARCHAR(13)='ABCdhved589' DECLARE @JOBIDSEQ VARCHAR(20) DECLARE @SFCIDSEQ VARCHAR(20) DECLARE @TCN VARCHAR(50) DECLARE @COUNT INTEGER EXEC GETNEXTSEQ 'HRSJobId', 0, 999999, @JOBIDSEQ output DECLARE @SLADueDate VARCHAR(8) WHILE(LEN(@JOBIDSEQ) BEGIN SET @JOBIDSEQ = '0' + @JOBIDSEQ END SET @COUNT = 1 WHILE @COUNT > 0 BEGIN EXEC GETNEXTSEQ 'HRSSFCID', 0, 46655, @SFCIDSEQ output WHILE(LEN(@SFCIDSEQ) BEGIN SET @SFCIDSEQ = '0' + @SFCIDSEQ END -- Calculate the new TCN SET @TCN = (SELECT [dbo].fngetSFCID(@SFCIDSEQ, @CARRIERID)) SELECT @COUNT = COUNT(*) FROM MDEZ_OOMFeed (nolock) WHERE TCN = @TCN END SELECT [dbo].fngetJOBID(@JOBIDSEQ) + ',' + @TCN + ',' + [dbo].[fngetFormName](@CARRIERID) + ',' + 'NNNNNN' + ',' + @CARRIERID + ',PROD'

Rajanikant Hawaldar · Answer

Post your sp here

Strored procedure

Answers (7)