I have the following issue since I moved from SQLite to SQL Server
Here is the log :
Completed 500 Internal Server Error in 45.0ms
ActiveRecord::StatementInvalid (TinyTds::Error: Incorrect syntax near the keyword 'AS'.: EXEC spexecutesql N'SELECT ,
((SELECT COUNT(1) FROM issues where project_id in (16) and status_id = issue_statuses.id)
/
72)_100 as percent,
(SELECT COUNT(1) FROM issues where project_id in (16) and status_id = issue_statuses.id)
AS totalissues
FROM issue_statuses;'):
Hello,
I have the following issue since I moved from SQLite to SQL Server
Here is the log :
Completed 500 Internal Server Error in 45.0ms
ActiveRecord::StatementInvalid (TinyTds::Error: Incorrect syntax near the keyword 'AS'.: EXEC spexecutesql N'SELECT , ((SELECT COUNT(1) FROM issues where project_id in (16) and status_id = issue_statuses.id) / 72)_100 as percent, (SELECT COUNT(1) FROM issues where project_id in (16) and status_id = issue_statuses.id) AS totalissues FROM issue_statuses;'):
I hope you will be able to fix it :)
Pierre