metabase shows results and we can visualise this. But when we wan’t to ask a question based on the saved question above, we cannot perform this and metabase tells us that there is an error ‘Incorrect syntax near the keyword ‘exec’.’
I read the post you suggested. This is still not working for me. Metabase tells me there is a incorrect syntax near exec. The question is bases on a stored proc in MS SQL. When I run this, de question shows me the result of the SP. When I want wo use MB to create a new question based on this question, it tells me “Incorrect syntax near…”. This apprears with and without SP 's that have parameters.
@wotikar Please post “Diagnostic Info” from Admin > Troubleshooting, and which version of MSSQL.
And when you see the “Incorrect syntax near…” error, then there should be a detailed error in Admin > Troubleshooting > Logs.