Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jodders
Starting Member
41 Posts |
 Posted - 2012-06-20 : 04:18:34
|
| Hi,Not sure where to post this so I thought I would try here.I am trying to cut down a tedious task which takes a couples of hours to put together and sometimes can be quite long winded. Human Error sometimes occurs and formatting is an issue as well I find.I have a number of SQL Select Statements which I normally run individually and paste them into an excel document (in various tabs) which then populates a header spreadsheet with all the information from the previous tabs automatically. The only variable that changes within each script is the Customer name.I have a table of Customers that I want to run a a report for. Ideally, I would like to have a "macro" or something along those lines which runs all those SQL Scripts,populates the results into excel spreadsheet with the results,convert to pdf and then move onto the next customer in the database?Does anybody do something similar or perhaps point me in the right direction to find out more information on this?Thanks |
|
|
|
|
|
Excel and a few sql select statements to run.