Thanks for the inputs

this is what i am trytig to do

Exec stored proc

result = Col1 (XML)

now how do i capture this into a variable and follow the procedure you provided ?

here is my SP Execution method

{DECLARE@return_value int

EXEC@return_value = [dbo].[bofa_sp_gap_sel_acc]

@SearchType = N'A',

@SearchInputList = N'94378495',

@FAsInputList = null

SELECT'Return Value' = @return_value

}

sorry for asking dumb questions (i have not worked in DB for a long time now)