Report question

Question: What are the best practices in writing a sql stored procedure