Posts by Nidorus • 59 points
9 posts
-
0
votes1
answer401
views -
0
votes3
answers1324
viewsA: Select records from one record to another in sql server
Good afternoon Buddy try it this way. USE vendateste GO WITH TesteVenda AS --Nesse Sub Select uso o ROW_NUMBER Para numerar a saída do conjunto do resultado ( SELECT ROW_NUMBER() OVER(ORDER BY…
-
1
votes1
answer4919
viewsQ: Comparing column values in dataframe pandas rows
Good afternoon. I am comparing two given frames, data frame 1 has an sql query and data frame 2 a mysql query I want to compare the two. When the DF 1 record is not in DF 2 I want to save the result…
-
-1
votes1
answer962
viewsQ: How to compare two Python data frames
Hello guys I am trying to automate a loading process with python bringing data from sql and sending to a mysql table and I am facing some problems. Problem: I need that when I have new data in my…
-
-1
votes3
answers2084
views -
1
votes1
answer79
views -
0
votes2
answers1609
viewsQ: Python Mysql database connection
Trying to make the connection to my database, but is returning me the following error! Exception has occurred: Attributeerror 'Connection' Object has no attribute 'execute' Exception has occurred:…
-
2
votes1
answer1508
viewsQ: SQL Server Connection - Python
Good afternoon guys I’m having trouble making a connection with sql, whenever I try to make the connection the following error occurs: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL…
-
0
votes1
answer62
viewsQ: Stored Procedures parameters
I have a question and I wanted to ask for your help. Next: I have a proc and I want when I don’t pass a parameter it returns to me null and when this happens bring the date of the day -1 and time…