I recommend that you download XLeratorDB and try this problem along with me, this is going to be a fun exercise and something new to learn about Business Days.
SQL SERVER – Number-Crunching with SQL Server – Exceed the Functionality of Excel
Management wants an Excel spreadsheet retired and its results stored in the database. Can SQL Server really match Excel’s financial and statistical functions?
Personal Technology – Excel Tip: Comparing Excel Files
Vinod Kumar of the Microsoft Technology Center shares a handy Excel tip on comparing Excel files full of data, formulas and multiple sheets.
SQL SERVER – Preserve Leading Zero While Coping to Excel from SSMS
Want to preserve leading zero values when you paste SSMS results into Excel? The fix is in Excel: format the cells as Text first, and the zeros stay.
SQL SERVER – Copy Column Headers from Resultset – SQL in Sixty Seconds #027 – Video
Copy column headers from resultset to Excel along with your data in SSMS, either once with Copy with Headers or always with one simple setting.
SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.