Click here to Skip to main content
11,704,107 members (50,006 online)
Rate this: bad
good
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
0 Maciej Los 530
1 OriginalGriff 510
2 Sergey Alexandrovich Kryukov 421
3 Andy Lanng 294
4 F-ES Sitecore 220
0 OriginalGriff 8,744
1 Sergey Alexandrovich Kryukov 7,747
2 CPallini 5,107
3 Maciej Los 4,716
4 Mika Wendelius 3,606


Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 6 Nov 2012
Copyright © CodeProject, 1999-2015
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