Looking for some guidance on best practices for organizing stored procedures. I have a stored proc that moves data from staging DB to a data warehouse and am wondering if it's best practice to put that stored proc in the staging DB or in the data warehouse DB?
