For complex report , I am creating CTE based sql view. In my view script there are multiple CTE. I want to filter every CTE with report input parameter so that less data get read by every CTE and report performance gets improve.
To achieve this I would like to follow the same steps to create sql view with parameter.
https://stackoverflow.com/questions/2281890/can-i-create-view-with-parameter-in-mysql
but I am confused as how to pass that parameter in DAC @p1 value so that the same parameter get reads by every cte.
