I need help with a Stored Procedure in SQL Server 2005
Posted on 2011-05-03
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,