spMerchantAccounts

CREATE procedure [dbo].[spMerchantAccounts] 
(
    @ClientsID int
)
AS
BEGIN
    set nocount on
    select -1 [id], '<please select>' [name], '00000000-0000-0000-0000-000000000000' [BBPSID], '' [ISO4217], '' [CurrencySymbol], 0 [CLIENTSITESID]
    union
    select id,name, BBPSID,
        convert(nchar(3), XMLTransactionInfo.query('data(/MATransactionInfo/ISO4217)')) [ISO4217],
        convert(nvarchar(3), XMLTransactionInfo.query('data(/MATransactionInfo/CurrencySymbol)') ) [CurrencySymbol],
        CLIENTSITESID
    from ClientMerchantAccounts where active=1 and ClientsID=@ClientsID 
END