Hello,
I have an interactive report with a super long query, in which it has dynamic statement based on different studies, then for each study it has a very long case when clause (at least 200 characters for each study). I don't know how many characters I can have for a sql query since we have over a dozen studies to handle, wonder if it's possible I can store the case when part for each study as a static parameter, then later feed it into the sql query when the study_id is passed. Although later it will still compose a big query to send to the database, but if it will be easier to maintain the query. Thanks.