Printing Statistics

Oct 12 2012 4:27 PM

Conceptually, what is the best way to create a report with a bunch of SQL statistics. I have 12-20 different counts I will pull from SQL, all individual Count statements, and I want to put the numbers on a report. Each count is for different tables and different where statements. Is it best to create a DataSet with 20 DataTables in it, each returning a single result?. If I was doing a form, I would probably do a bunch of executescalar commands. Thanks.

Answers (1)

Self Join in SQL

HI. How to rename a table name or column name in sql?