79454394

Date: 2025-02-20 11:56:25
Score: 2
Natty:
Report link

I have been looking at this recently, and as they are similar in nature (and no one can agree) I think using a Procedure with stored @PArams is good if you want to make available to data analysts using a paginated system such as Power BI report builder. when they connect to it, it ingests all the controls and filers into the report definition and sets up the @Params allowing "non SQL" minded analysts to build the reports safely. Using a View - would require them to add the params at report level manually, and/or allow them to accidentally leave them out or add incorrect parameters. (not to be confused with hard coded where clauses).

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • User mentioned (1): @PArams
  • User mentioned (0): @Params
  • Low reputation (1):
Posted by: David Hughes