Click here to Skip to main content
12,399,975 members (48,614 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-Server
Hi,

Shall we write Stored procedure within the another Stored Procedure. Any one can suggest me.
Posted 5-Nov-12 20:50pm
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Futher to "Kankeyan's" solution above bit more detailed

STEP 1 : Create the fist procedure

create procedure spProcedure1 (@id int)
as
Begin
    Select 'Procudure1 id value=' +STR (@id)
 
End


STEP 2 : Create the second procedure, Second procedure is calling the first procedure within

create procedure spProcedure2 (@id2 int)
as
Begin
    Declare @id3 int
    Select 'Procudure2 id value=' +STR (@id2)
    set @id3=@id2*2
    exec spProcedure1 @id3
 
End


STEP 3: Call the second procedure with a sample paramter

spProcedure2 10


Analyse the output and hope its self explanatory
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

YOu can write the two or more stored procedure and call the stored procedure in on stored procedure with necessary inputs

Create Proc Sample
(
Parameters
)
As
BEGIN
some condition
Exec sample 2

END


hope will it helpful
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 6 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100