65 lines
1.8 KiB
SQL
65 lines
1.8 KiB
SQL
select * from vetb00002
|
|
where fech_crea>'2023-12-01'
|
|
|
|
|
|
update vetb00002
|
|
set orden = null
|
|
where orden=2
|
|
|
|
|
|
update vetb00002
|
|
set conduce = null
|
|
where conduce=90001
|
|
|
|
|
|
SELECT *
|
|
FROM vetb00004 a
|
|
WHERE a.tipo_cliente = 16 AND
|
|
a.sec_cliente = 187
|
|
|
|
|
|
delete from vetb00028
|
|
WHERE tipo_cliente = 16 AND
|
|
sec_cliente = 187
|
|
|
|
|
|
insert into vetb00004
|
|
(tipo_cliente, sec_cliente, nombre, cod_zona, cod_provincia, telefono, fax, telex, patente, limite_credito, zona_postal, num_rnc, nombre_patente, status_t, us_crea, fech_crea, us_mod, fech_mod, Puesto_laboral,
|
|
telefono_casa, tipo_negocio, cond_pago, id_ciudad, url, id_crm)
|
|
SELECT tipo_cliente, sec_cliente, nombre, cod_zona, cod_provincia, telefono, fax, telex, patente, limite_credito, zona_postal, num_rnc, nombre_patente, status_t, us_crea, fech_crea, us_mod, fech_mod, Puesto_laboral,
|
|
telefono_casa, tipo_negocio, cond_pago, id_ciudad, url, id_crm
|
|
FROM ndecobk.dbo.vetb00004
|
|
WHERE tipo_cliente = 16 AND
|
|
sec_cliente = 187
|
|
|
|
|
|
|
|
select * from iptb00006
|
|
where num_doc=90001
|
|
|
|
|
|
select * from prtb00012
|
|
where num_oc=2
|
|
|
|
|
|
SELECT CONVERT(char(10),a.fecha_oc,103),a.ubicacion,a.nombre_file,
|
|
a.cond_pago,b.descrip,b.dias,a.cotizacion_no
|
|
|
|
|
|
FROM prtb00012 a,vetb00012 b
|
|
WHERE a.num_oc = 2 AND
|
|
a.tipo_cliente = 16 AND
|
|
a.sec_cliente = 187 AND
|
|
a.cond_pago = b.cond_pago AND
|
|
a.status_t IS NULL
|
|
|
|
|
|
insert into prtb00013
|
|
select * from ndecobk.dbo.prtb00013
|
|
where num_oc=2
|
|
|
|
select * from vetb00072
|
|
where documento=8699
|
|
|
|
|