Posts by Peterson • 11 points
3 posts
-
0
votes2
answers299
viewsA: How to use a variable to delete with like? SQL Server
You can use a dynamic query, as the example below EXEC(N'DELETE FROM LJ_ETL_REPOSITORIO WHERE ID_ETL_TIPO=''171'' AND FILTRO LIKE ''%' + @NOME_FILIAL + '%''')
-
0
votes2
answers34
viewsA: Record duplicity between two tables
You need to do something like this SELECT t1.NumeroTelefone FROM tabelaTelefone1 t1 INNER JOIN tabelaTelefone2 t2 ON t1.NumeroTelefone = t2.NumeroTelefone…
-
1
votes1
answer53
viewsA: Recover orders customer 1. DUPLICATION ERROR
According to the table and query you showed, apparently the result is not duplicated because: In the clause WHERE I noticed that to get customer’s orders ELECTROMATIC DE GARCA LTDA you restrict the…