Error
Se produjo un error al acceder a la base de datos
Incorrect syntax near ')'. [20018] (severity 15) [select count(*), sum(Cargo), sum(Abono) from (select x.* from ( select 1 as orden,ta.clave as Tipo_doc, ta.clave as Tipo, ta.clave as Serie, cast(ab.numero_docto as nvarchar(50)) as Documento, ab.fecha_docto as Fecha, ab.beneficiario as Proveedor_beneficiario, 'Emsion de cheque' as Tipo_gasto, ab.moneda2 as Moneda, 0 as Cargo, ab.valor as Abono from abo_cxp ab inner join tipabcxp ta on (ab.tipo_abono_cxp = ta.numero_interno) where referencia = and clasificacion <> 'LQ' and ab.moneda2 = 'US' union select 2, cg.tipo_cgo_cxp, (case when dt.t_docto_sat = 'F' then 'Factura' when dt.t_docto_sat = 'R' then 'Recibo' else '' end), dt.serie, rtrim(dt.factura), dt.fecha_factura,dt.nombreproveedor, tg.descripcion, '$', dt.vlr_total,0 from detcompr dt inner join cgo_cxp cg on (cg.numero_interno = dt.key_cgo_cxp) and cg.moneda2 = 'US' inner join tbl_ot_t_gasto tg on (tg.id = dt.ot_t_gasto) where orden_pago = and clasificacion <> 'LQ' union select 3, cg.tipo_cgo_cxp,(case when dt.t_docto_sat = 'F' then 'Factura' when dt.t_docto_sat = 'R' then 'Recibo' else '' end), '', rtrim(dt.factura), dt.fecha_factura,dt.nombreproveedor, tg.descripcion, '$', dt.vlr_total, dt.vlr_total from detcompr3 dt inner join tbl_ot_t_gasto tg on (tg.id = dt.ot_t_gasto) inner join cgo_cxp cg on (cg.numero_interno = dt.key_cgo_cxp) and cg.moneda2 = 'US' where ot = )x ) nm_sel_esp ]
select count(*), sum(Cargo), sum(Abono) from (select x.* from ( select 1 as orden,ta.clave as Tipo_doc, ta.clave as Tipo, ta.clave as Serie, cast(ab.numero_docto as nvarchar(50)) as Documento, ab.fecha_docto as Fecha, ab.beneficiario as Proveedor_beneficiario, 'Emsion de cheque' as Tipo_gasto, ab.moneda2 as Moneda, 0 as Cargo, ab.valor as Abono from abo_cxp ab inner join tipabcxp ta on (ab.tipo_abono_cxp = ta.numero_interno) where referencia = and clasificacion <> 'LQ' and ab.moneda2 = 'US' union select 2, cg.tipo_cgo_cxp, (case when dt.t_docto_sat = 'F' then 'Factura' when dt.t_docto_sat = 'R' then 'Recibo' else '' end), dt.serie, rtrim(dt.factura), dt.fecha_factura,dt.nombreproveedor, tg.descripcion, '$', dt.vlr_total,0 from detcompr dt inner join cgo_cxp cg on (cg.numero_interno = dt.key_cgo_cxp) and cg.moneda2 = 'US' inner join tbl_ot_t_gasto tg on (tg.id = dt.ot_t_gasto) where orden_pago = and clasificacion <> 'LQ' union select 3, cg.tipo_cgo_cxp,(case when dt.t_docto_sat = 'F' then 'Factura' when dt.t_docto_sat = 'R' then 'Recibo' else '' end), '', rtrim(dt.factura), dt.fecha_factura,dt.nombreproveedor, tg.descripcion, '$', dt.vlr_total, dt.vlr_total from detcompr3 dt inner join tbl_ot_t_gasto tg on (tg.id = dt.ot_t_gasto) inner join cgo_cxp cg on (cg.numero_interno = dt.key_cgo_cxp) and cg.moneda2 = 'US' where ot = )x ) nm_sel_esp