mainrotor
asked on
I need help with a Stored Procedure in SQL Server 2005
Hi Experts,
I have a SQL Server 2005 Stored Procedure spGetAccountInfo which takes one parameter. When I execute it from SQL Server the syntax looks like this:
EXEC spGetAccountInfo '1'
and it returns the following fields:
AccountID, AccountNo, AccountName, AccountCode, and Type
I want to create a new Store Procedure that calls this Stored Procedure (spGetAccountInfo) but only returns the AccountName and AccountCode columns for the AccountID i pass in as a parameter.
How can I do this?
Thanks in advance,
mrotor
I have a SQL Server 2005 Stored Procedure spGetAccountInfo which takes one parameter. When I execute it from SQL Server the syntax looks like this:
EXEC spGetAccountInfo '1'
and it returns the following fields:
AccountID, AccountNo, AccountName, AccountCode, and Type
I want to create a new Store Procedure that calls this Stored Procedure (spGetAccountInfo) but only returns the AccountName and AccountCode columns for the AccountID i pass in as a parameter.
How can I do this?
Thanks in advance,
mrotor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.