proveedor nvarchar(30);

nitvarchar nvarchar(30);

prop_cc nvarchar(30);

proveedor := $[OPCH.CardCode];

nitvarchar := $[OPCH.U_nit_prov];

prop_cc := QryGroup10;

Select prop_cc from OCRD where CardCode = proveedor if prop_cc = 'Y' Select U_NRC FROM "DISMOSAL_PRUEBAS"."@PROVEEDOR_CAJACHICA" WHERE U_NIT= nit Else Select AddID From OCRD Where CardCode = proveedor