Output Parameter in select statement of sql while calling stored procedure

Question

0.00/5 (No votes)

See more:

Hello,i have a stored procedure sp1,having structure like this

C#

create procedure sp1 
@id int,
@name varchar(5),
@rank int output

And i have one more stored procedure like this

C#

create procedure sp2 
@user varchar(50)

In this sp2 procedure i need to call sp1 like:

C#

exec sp2(select id,name,rank from tbltemp where name!=null)

But it is throwing error like

<br />
<br />
Procedure or function 'sp2' expects parameter '@rank', which was not supplied.

Thanks for any help in advance.

Posted 3-Dec-13 21:54pm

njdcjk

Updated 3-Dec-13 22:18pm

Thanks7872

v2

Add a Solution

Comments

Mahendran Murugesan 4-Dec-13 4:22am

Hi,
1. You cannot pass the sql statement directly to SP2
2. You need to pass single row value to sp1 inside SP2 using select statement with row selector.

pass the value as shown in below format
Declare @id int
Declare @name varchar(5)
Declare @rank int
Select top 1 @id = id, @name = name from tbltemp where name != null -- top 1 include to select first user.
Exec sp1 @id , @name, @rank out
select @rank

Hope it helps

Maciej Los 4-Dec-13 17:55pm

Please, post it as an answer and i'll promise you to upvote your answer ;)

njdcjk 4-Dec-13 4:58am

Thanks a lot.U saved my day.+1

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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