Hello
I have generated xml using sql query
please see below query
SELECT
ft.fee_text AS FeeType ,
ISNULL(ft.fee_desc,'') AS FeeDescription ,
0 AS IncludeInPremium ,
fee.fee_amt_with_tria AS FeeAmount
FROM
dbo.bms_fees fee
INNER JOIN dbo.adm_bm_fee_map feeMap ON fee.fee_map_id = feeMap.fee_map_id
INNER JOIN dbo.adm_bm_fee_items FI ON FI.fee_item_id = feeMap.fee_item_id
INNER JOIN dbo.adm_bm_fee_types FT ON FT.fee_type_id = FI.fee_type_id
and fee.fee_type_code='BROKERAGE'
WHERE
...
Go to the complete details ...