SELECT queries per report

• DataAnalyst110

  Ten Centuries

  Points: 1361

  More actions

  April 17, 2012 at 9:42 am

  #255032

  I have a report I'm working on that is fairly complex. Are there any best practices regarding how many individual SELECT statements are used in a single report (i.e. from different data sets)? This one could have close to 18 because each of the entities is so different.

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  April 17, 2012 at 11:07 am

  #1474907

  The only thing I would say is to move your queries to stored procedures.