Convert int to Excel column name
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
1,961 reads
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
1,961 reads
SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates the advantages of the graphical approach of SSIS. Andy Brown explains.
2013-06-13
7,885 reads
This article details an Excel 2010 function to return the cell address of min and max functions.
2013-06-04
5,910 reads
So you want to group your data for charting in Excel? Here's how, the easy way!
2012-07-31
5,330 reads
This article demonstrates using SQL Server's data mining capabilities with the Excel.
2011-02-11
5,472 reads
Have you ever been required to create a database with nothing but a specification in Excel?
2009-11-12
7,620 reads
Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.
2009-01-09
2,868 reads
This article focuses upon Column charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in Introducing Reporting Services Charts for Analysis Services.
2008-12-19
2,293 reads
There is value in using the extended properties across some of the industry leading data modeling tools. What if I do not have access to any of those tools? Is it possible to build the extended properties and then be able to generate reports by using Excel or Reporting Services?
2008-12-09
4,930 reads
2010-02-19 (first published: 2008-12-05)
38,409 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers