Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Content with tags
T-SQL
,
Excel
Items 1 to 3 of 3
Set Up Grouping Intervals for Excel (SQL Spackle)
So you want to group your data for charting in Excel? Here's how, the easy way!
Read more...
By
Dwain Camps
2012/07/31
|
Source:
SQLServerCentral.com
|
Category:
excel
Rating:
|
Discuss
|
Briefcase
|
5,104 reads
Import Excel Spreadsheet to Database Tables
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.
Read more...
By
Peter He
2010/02/17
|
Source:
SQLServerCentral.com
|
Category:
etl
Rating:
|
Discuss
|
Briefcase
|
17,225 reads
Use Excel to DIFF Your Query Outputs
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.
Read more...
By
David Ziffer
2008/12/31
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,290 reads
Items 1 to 3 of 3
Tags
etl
(1)
histogram chart
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.