Open CyloNox opened 2 months ago
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.
Same as #720 , #679
festerman
commented
2 months ago
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.