Posts by Bruno Almeida • 39 points
6 posts
-
0
votes1
answer166
viewsA: SQL UPDATE SUM VALUE NOT NULL
After some time of research here is : UPDATE Matrix SET nStock=COALESCE(( SELECT sum(stock) as TotalStock FROM stock INNER JOIN Vis_Armazem ON stock.Sloc=Vis_Armazem.Sloc WHERE Vis_Armazem.mostrar=1…
-
0
votes1
answer166
viewsQ: SQL UPDATE SUM VALUE NOT NULL
dataTmp referencia nStock 2017-02-18 DC01234567 NULL 2017-02-18 DC01234567 NULL 2017-02-18 DC01234567 NULL 2017-02-19 DC01234567 0 2017-02-19 DC01234567 0 2017-02-19 DC01234567 0 2017-02-20…
-
0
votes4
answers1225
viewsA: How do I write a store that uses current and previous line values?
with estoqueAtual as ( SELECT id_Matrix, dataTmp, referencia, id2, nStock, nProduz, necessidade,turno, novoStock= nStock from Matrix where dataTmp=(select dateadd(dd,0, cast(getdate() as date))) and…
-
2
votes4
answers1225
viewsQ: How do I write a store that uses current and previous line values?
I have the following table, # id # dataTmp # referencia #nProduz#nStock # id2 #necessi# # 115237 # 31-01-2017 # VL03280103 # 0 # 0 # 6 # 0 # # 115238 # 01-02-2017 # VL03280103 # 0 # 0 # 7 # 0 # #…
-
0
votes5
answers1205
viewsA: command given ajax json for php
I use it a lot: var PrimeiroNome=$("#InputPrimeiroNome").val(); $.post("pagina2.php",{nome:PrimeiroNome}).done(function(resultado){ $("div #recebeValor").html(resultado); }); Basically inside the…
-
0
votes0
answers26
viewsQ: sql stored Update Value With value from the previous record in the same table
I have a table with several repeated names sequenced by another column called id2 where each 1 of these records has a column with a quantity Example : Name-Quantity-Value2-id2 teste1-1000-0-1…