Link to home
Start Free TrialLog in
Avatar of mainrotor
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
ASKER CERTIFIED SOLUTION
Avatar of wdosanjos
wdosanjos
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial