Posts by Lucas da Costa • 39 points
6 posts
-
0
votes1
answer65
viewsA: Matplotlib graphics are overwriting themselves
Hello! I just reversed their statement and generated correctly, as part of your code: bar(title='Bar H', values=values, labels=labels, orientation='h') pie(title='Pie', values=values, labels=labels)…
-
0
votes1
answer323
viewsA: Return mysql query in python list
Hello! I made a query using Python’s Sqlite3 and saving the return of the query in a "txt" file. I hope it helps you. import sqlite3 conteudo = [] conection = sqlite3.connect('banco.db') c =…
-
0
votes3
answers47
viewsA: Sql return generation limit
Please try then the command below, I changed only to insert limit to 5 records, instead of 10 which is. DECLARE @serie INT, @ordem INT, @Periodo INT DECLARE @tbResultado TABLE ( id INT IDENTITY(1,1)…
-
2
votes1
answer41
viewsA: Validate parameter to disregard left Join
Hello! You can take a look at the use of CASE with LEFT JOIN, as link below: Using Case When with Leftjoin I hope it helps you. Abs!…
-
0
votes3
answers47
viewsA: Sql return generation limit
Good afternoon! Instead of using SELECT * FROM @tbResulted, because it does not use SELECT TOP 5 * FROM @tbResulted? That way, instead of fetching all records from the @tbResulted table, it will…
-
0
votes3
answers6516
viewsA: How to convert varchar to Numeric in SQL?
Good afternoon! Try to convert both to VARCHAR and compare, probably some CPF is with characters different than expected. If this does not work, try to make a TOP 10 and check if any data is…