How do i call procedure result into another

indradaman sharma
indrada...
Participant
54 Points
17 Posts

This is my first store procedure

CREATE PROCEDURE SP_GetValue1
AS
BEGIN

SELECT CustomerID, CustomerName, UserID, Password, CompanyName, IsVerified, IsActive, InsertedID, InsetedDate, UpdatedID, UpdatedDate, IPAddress
FROM Login_Customer

END

It give me back table with column.

Now i wan to create second store procedure 

GetValue2 and use my first procedure in it and want to get column CustomerName, UserID, Password, CompanyName. How do i get it,

Please help me

 

Views: 8131
Total Answered: 1
Total Marked As Answer: 0
Posted On: 07-Mar-2017 05:43

Share:   fb twitter linkedin
Answers
Rahul Maurya
Rahul M...
Moderator
1170 Points
210 Posts
     

Hi indradaman,
I think, we can't return from procedure in t-sql. Also we can not use table as output parameter. So it is better to use function to return table. If it is necessary, you can use some table to store  and insert from first procedure and get through second procedure. 

Posted On: 07-Mar-2017 07:04
banner

Blog

Active User (2)

 Log In to Chat