Posts by c3s1 • 29 points
6 posts
-
0
votes1
answer48
viewsQ: Add values with different codes
good evening, I have the script below: SELECT Month([doacao_total].[doacao_sdt_data]) AS MES, Year([doacao_total].[doacao_sdt_data]) AS Ano, Sum(doacao_total.doacao_mon_valor) AS [Valor_doacao],…
-
-2
votes1
answer1003
viewsQ: SQL - Show the top 10 values per month
I would like to show on the screen the 10 highest donation values of each month of the year 2018 table Doacao. My database is SQL SERVER. For now I have the following query: select…
sql-serverasked c3s1 29 -
0
votes1
answer68
viewsQ: Monitor if files were inserted in a specific folder
Good morning friends, I would like an opinion or dirty from you in the following situation: In one of the company’s clients who work in the financial sector daily makes a download of an archive of…
-
0
votes0
answers238
viewsQ: Connect the SQL SERVER instance
Good evening friends. I have installed in a machine SERVER a system that uses SQL SERVER, the client machine is in another city, to connect the two in the same network we made a VPN using the own…
sql-serverasked c3s1 29 -
1
votes1
answer142
viewsA: Copy table A column to table B sql
SOLVED !!! Actually table A has 'N' number of cities, and it repeats several times, and two cities can have the same name in different states, so my query returned a larger amount of records, I…
-
1
votes1
answer142
viewsQ: Copy table A column to table B sql
Good afternoon Personal, I have two tables and I need to make a SELECT to link the code of the cities that are in table B with the cities in table A. I am using the query: select a.Cidade, b.Cidade,…