We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Running 2004.sql on a sql server hit a max amount of characters for a CTE. All that I did was split it out into two CTEs and do the insert at the bottom with both. Here is the analysis file with the line where I made a second CTE: https://github.com/JH-TIC/Achilles/blob/main/inst/sql/sql_server/analyses/2004.sql#L674
It's a simple fix but would be nice to include this on the next release so I don't have to slightly modify the code.
The text was updated successfully, but these errors were encountered:
Same as #720 , #679
Sorry, something went wrong.
Replace SQL Server code for analysis 2004 w/version that doesn't break.
c20e0e4
Fixes OHDSI#679, OHDSI#720 and OHDSI#771
No branches or pull requests
Running 2004.sql on a sql server hit a max amount of characters for a CTE. All that I did was split it out into two CTEs and do the insert at the bottom with both. Here is the analysis file with the line where I made a second CTE: https://github.com/JH-TIC/Achilles/blob/main/inst/sql/sql_server/analyses/2004.sql#L674
It's a simple fix but would be nice to include this on the next release so I don't have to slightly modify the code.
The text was updated successfully, but these errors were encountered: