title: How is writing SQL queries for reports different?
body: <p>How does writing SQL queries for reports, which often are just run once a week, once a month or some infrequent amount, differ from writing queries for web applications (or applications) which are run many times a day? If a query runs only once a month, speed and performance isn't a big issue, correct? How about in terms of using aspects of SQL more frequently (temp tables, CTEs, etc)?</p>