Today I had a requirement to save the results of an SQL query into a sql table. Usually it is easy to export to excel by using the option of copying the results and pasting them to an excel file. But this time I had over a million rows and I didnot want to use excel to store that huge amount of data. So I followed the following 2 simple steps. 1. Create a new table in a new database: Use the SSMS to create the database and use the create table query to create the new table as follows: create tab...
Read More
Yesterday I had this requirement to add number of months (m) to a cell that contains start date to estimate the end date. In 2003 I had to use a complex formula like below where A1 is the cell that contians the start date. =DATE(YEAR(A1),MONTH(A1)+m,DAY(A1)) Well in Excel 2007 it is even more easy to add months with the Edate function like below. =Edate(A1, m).