Resources
Posts Tagged "Excel"
Check out all of the posts tagged with "Excel".
Find numbers within a string in Excel
Learn how to use excel to extract numbers from strings.
Jul, 14
Working with Seconds in Excel
I recently had to use back end data from SQL Server to deliver several reports in excel. All of my SQL code gave me results in seconds; however, the users had distinct formatting requests. I would have to use a few excel tricks to get things just right in each report.
May, 24
Importing Data into SQL Server – Using Excel Shortcuts
I’ll be the first to say, the switch from DTS to SSIS was painful. DTS would go through a lot of implicit conversions so you didn’t have to worry or think about them. But SSIS ...
Mar, 17
Navigation
Please use the navigation to move within this section.