A Fine Slice Of SQL Server
Jose Manuel Jurado Diaz collects a compendium of errors:
1) pyodbc.Error: (‘HY000’, ‘[HY000] [Microsoft][ODBC Driver 17 for SQL Server]Connection is busy with results for another command (0) (SQLExecDirectW)’)
This error ocurrs when the Python code is trying to open a new cursor when we have a previous one with results.
Read on for examples of the problem and solutions for each.
Comments closedImke Feldmann has a function for us:
Finally 2023 is here, the year we expect Power Query function libraries to ship. This will make it so much easier to re-use ready made function than M-extensions. So let’s start collecting some fodder for it, by creating a function to calculate the Present Value (PV) for Power Query:
Click through for that function, as well as an explanation of what it’s doing.
Comments closed