Posts by Celso • 11 points

• 0

  votes

  1

  answer

  38

  views

  A: How to update a select with sub queries that contain Group by and order by

  Solution found to the above problem. UPDATE tbl_SaldoAtual SET SaldoAtual = Soma FROM (SELECT TOP(15) WITH TIES t1.Ordenado, SUM(t2.SaldoInicial + T2.Credito - T2.Debito) as Soma FROM tbl_SaldoAtual…

  sql sql-server

  answered 4 years, 2 months ago Celso 11

• -1

  votes

  1

  answer

  38

  views

  Q: How to update a select with sub queries that contain Group by and order by

  Physical Table Registro IDBanco DataMovimento Credito Debito SaldoAtual Ordenado 1 26 2020-07-05 500,00 0,00 0,00 5 2 26 2020-07-03 0,00 10,00 0,00 3 3 26 2020-07-06 0,00 20,00 0,00 6 4 26…

  sql sql-server

  asked 4 years, 2 months ago Celso 11