SQLServerCentral.com Content tagged T-SQL, Excel

Set Up Grouping Intervals for Excel (SQL Spackle)

Tue, 31 Jul 2012 06:00:00 UT

So you want to group your data for charting in Excel? Here's how, the easy way!

Import Excel Spreadsheet to Database Tables

Wed, 17 Feb 2010 07:00:00 UT

Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

Use Excel to DIFF Your Query Outputs

Wed, 31 Dec 2008 07:00:00 UT

Comparing data from two queries to see if they return the same results can be an interesting challenge. David Ziffer brings us a great way to do this using Excel.