CREATE PROCEDURE accountprofile
    @accountid varchar(50),
	@accountname varchar(50) OUTPUT,
	@fundtype varchar(50) OUTPUT,
	@balance INT OUTPUT,
	@fundname varchar(50) OUTPUT,
	@year varchar(4) OUTPUT,
	@allocation INT OUTPUT
AS 
    SELECT @accountname = accountname, 
	@fundtype = fundtype, 
	@balance = balance, 
	@fundname = fundname,
	@year = year, 
	@allocation = allocation
    FROM assetallocation
    WHERE accountid = @accountid;