All Questions
5 questions
2
votes
1
answer
135
views
Need assistance in Optimizing the Recursive Query in Pyspark
I am trying to convert a SQL Server stored procedure to Pyspark code.
This is my SQL Server query:
...
- 21
2
votes
2
answers
146
views
Receive data from SQL and CSV and send it to MySQL database using Python
Details:
I have a code, which does the following:
Get data from CSV and insert it into MySQL table
Get data from SQL Server and insert it into MySQL table
Run this code every 240 seconds - to refresh ...
- 235
5
votes
1
answer
153
views
Excel to SQL server
I am self-taught when it comes to coding. I want to improve, so please give me advice if I have some bad habits or if there is in general a better way of doing this.
The idea of this code is to look ...
- 153
4
votes
1
answer
72
views
JSON from SQL Server: Reduce lists of single dicts to list of values
SQL Server 2016 introduced some JSON features, but they're far from robust. As far as I can tell, there's no way yet to output a simple array; everything must be in ...
- 143
3
votes
1
answer
394
views
Reading Database, scraping Barchart and uploading prices to DB
This is my first real excursion into Python, coming from C#. I wanted to see if my code is well-formatted and efficient.
The following will read the needed codes from a Database Table, then submit ...
- 208