Posts by Eduardo Silva • 111 points

• 0

  votes

  1

  answer

  46

  views

  A: Query to remove duplicates entering apparent infinite loop

  First you need to know which lines are duplicated. Then undo all but one. So: DELETE A FROM tbl_atividades A INNER JOIN ( SELECT MIN(codigo) AS codigo, cod, tipo_atividade, dt_vencimento, COUNT(*)…

  mysql sql

  answered 5 years, 5 months ago Eduardo Silva 111

• 1

  votes

  2

  answers

  46

  views

  A: Insert records that only exist in the source table with MERGE

  I think you have to remove the conditions from the initial query and put their conditions as columns. So you will make MATCH whenever there is registration (regardless of the other conditions) but…

  sql sql-server

  answered 5 years, 5 months ago Eduardo Silva 111