BEGIN TRY
select @account = v_accountno from VENDORS where v_id = 4
SELECT
(
SELECT epi_lastname + ', ' + epi_firstname AS "@orderID",
so_dateordered AS "@orderDate",
--'new' AS "@type",
--'USD' AS "Total/Money/@currency",
(
SELECT svslb_externalid as "@addressID",
'en' as "Name/@xml:lang",
CASE sdm_sdmtid
WHEN 2 THEN epi_lastname +', '+ epi_firstname
WHEN 3 THEN so_orderedby
WHEN 1 THEN branch_name
END as "Name",