October 8, 2008 01:36am pdt

1. brent_ca... 23,090
2. Bamit99 18,544
3. KCTS 9,772
4. talker2004 9,000
5. mmilic 8,000
6. bhanukir7 7,989
7. larstr 7,740
8. tigermatt 7,172
9. kevinhsieh 6,400
10. jss1199 6,000
10. graye 6,000
10. ebjers 6,000
13. oBdA 5,500
13. SteveH_UK 5,500
15. garycase 5,000
15. Halindar 5,000
17. leew 4,900
18. bbao 4,828
19. dwarren... 4,500
20. wwwally 4,300
21. Kelv1979 4,000
21. twcadmin 4,000
21. wawrzek 4,000
21. ScooterA... 4,000
21. CrashDu... 4,000

1. brent_ca... 23,090
2. Bamit99 20,144
3. KCTS 9,772
4. talker2004 9,000
5. mmilic 8,000
6. bhanukir7 7,989
7. larstr 7,740
8. SteveH_UK 7,500
9. tigermatt 7,172
10. leew 6,900
11. kevinhsieh 6,400
12. jss1199 6,000
12. graye 6,000
12. ebjers 6,000
15. oBdA 5,500
16. garycase 5,000
16. Halindar 5,000
18. bbao 4,828
19. dwarren... 4,500
20. wwwally 4,300
21. Kelv1979 4,000
21. CrashDu... 4,000
21. wawrzek 4,000
21. twcadmin 4,000
21. ScooterA... 4,000

06.18.2008 at 11:35AM PDT, ID: 23496345

	[x] Attachment Details

Use output parameter in a store proc

Asked by pratikshahse in Microsoft Virtual Server 2005, SQL Server 2005

Tags: Microsoft, SQL Server, 2005

I have two store procs : proc 1 and proc 2.

inside proc 1 i call proc 2. proc 2 has an output parameter @var1. after running proc 2 i return back to proc 1. when i come back to proc 1 i want to use the output parameter from proc 2. can i do that. please give me an example.Start Free Trial

Keywords: Use output parameter in a store proc

	Title
1	Stored procedure... Parameter Pro…
2	Calling a SQL 2005 stored proc wit…
3	Using Stored Procedure and trying to u…
4	Calling Stored Proc. with optional par…
5	Calling stored procedures with paramet…
6	parameters in stored proc

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Use output parameter in a store proc

Asked by pratikshahse in Microsoft Virtual Server 2005, SQL Server 2005

Tags: Microsoft, SQL Server, 2005

About this solution