sql - Catching last datetime after update wont result -


i have following code:

update sm  set  sm_fecha_venc = (select min(nd_fecha_venc) [db_facturacion].[dbo].[tb_notas_debito]                              sm_codigo = nd_num_servicio                             -- , nd_referencia = sm_cod_producto                                 , nd_num_factura = sm_cod_factura                                  , nd_estado = 'g')     ,sm_fecha_ult_pago = (select max(nd_fecha_pago) [db_facturacion].[dbo].[tb_notas_debito]                              sm_codigo = nd_num_servicio                             -- , nd_referencia = sm_cod_producto                                 , nd_num_factura = sm_cod_factura                                  , nd_estado = 'c')      ,sm_fecha           = getdate()     ,sm_cod_factura_ren = @i_num_factura     output deleted.sm_fecha_venc      fecha_venc_old,           deleted.sm_fecha_ult_pago  fecha_ult_pago_old,           deleted.sm_fecha           fecha_old,           deleted.sm_cod_factura_ren cod_factura_ren_old     @tablatabla -- [db_facturacion].[dbo].[tb_servicios] sm --with(nolock) inner join #servicios t  on sm_codigo = num_servicio sm_tipo_bien_protegido = 1 , [sm_estado] = 1 --and sm.sm_cod_forma_contrato = 1 , sm.sm_tipo_inventario = tipo_inventario    /*===========================        inserted deleted  =============================*/  update db_facturacion.[dbo].[tb_log_cambio_servicio] set         cs_fecha_venc_old        = fecha_venc_old            ,cs_fecha_ult_pago_old    = fecha_ult_pago_old                                                          ,cs_fecha_old             = fecha_old            ,cs_cod_factura_ren_old   = cod_factura_ren_old @tablatabla         cs_codigo = @id_ultimo_ing  (last @@identity)

im trying save last dates log table, in case have return dates back.

the code works good, it's catching actual date , inserted in log table.

what missing?


Comments

Post a Comment

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

Image
i developing site in angularjs ui-router. have situation on button click need change , load 3 state page , 3 looks image .please me how can load multiple pages. in 1 page you need configure router config this: $stateprovider .state("state1", { url: "/url1", controller: "firstcontroller", views: { view1: { templateurl: "templates/template1.html" }, view2: { templateurl: "templates/template2.html" }, view3: { templateurl: "templates/template3.html" } } }).state("state2", { url: "/url2", controller: "secondcontroller", views: { view1: { templateurl: "templates/template4.html" }, view2: { templateurl: "templates/template5.html" }, view3: { templateurl: "templates/template6.html" } }).state("state3", { ...
Read more

python - GRASS parser() error -

i'm trying use grass on python 2.7, i'm having problems @ setting script on idle, i'm getting error @ parser() function: here script: import os import sys gisbase = os.environ['gisbase'] = 'c:\program files (x86)\grass gis 7.0.1rc1' gisrc = 'c:\grassdata' gisdbase = 'c:\grassdata' location = 'newlocation' mapset = 'tc' ld_library_path = 'c:\program files (x86)\grass gis 7.0.1rc1\lib' path = 'c:\program files (x86)\grass gis 7.0.1rc1\etc';'c:\program files (x86)\grass gis 7.0.1rc1\etc\python';'c:\program files (x86)\grass gis 7.0.1rc1\lib';'c:\program files (x86)\grass gis 7.0.1rc1\bin';'c:\python27';'c:\program files (x86)\grass gis 7.0.1rc1\python27';'c:\program files (x86)\grass gis 7.0.1rc1\msys' pythonlib = 'c:\python27' pythonpath = 'c:\program files (x86)\grass gis 7.0.1rc1\etc\python' sys.path.append(os.path.join(os.environ['...
Read more

json - Gson().fromJson(jsonResult, Myobject.class) return values in 0's -

Image
i have json {"fechaupdateid":1,"fechasegundos":635902782941643690,"fechasegundosbc":635902779020935030} i execute command convert object fechaupdate dto = new gson().fromjson(json, fechaupdate.class); but got result this fechaupdate class public class fechaupdate { public int getfechaupdateid() { return fechaupdateid; } public void setfechaupdateid(int fechaupdateid) { this.fechaupdateid = fechaupdateid; } public long getfechasegundosbc() { return fechasegundosbc; } public void setfechasegundosbc(long fechasegundosbc) { this.fechasegundosbc = fechasegundosbc; } public long getfechasegundos() { return fechasegundos; } public void setfechasegundos(long fechasegundos) { this.fechasegundos = fechasegundos; } private int fechaupdateid ; private long fechasegundos ; private long fechasegundosbc; } solved ...
Read more