Rudy Rodarte . com

Posts Tagged "Excel"

Check out all of the posts tagged with "Excel".

Learn how to use excel to extract numbers from strings.

Find numbers within a string in Excel

Learn how to use excel to extract numbers from strings.

Jul, 14
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.

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

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.