Latest Blog Posts for My Tech Learning

• Getting the first date of the month in SQL without any functions
  on Feb 25, 2014 in SQL
  One of the date columns in my database is an integer as it is a dimension keyI was trying to get some results grouped for the whole month by this date integer column.This is how I went about getting it in an easier manner without using any DATEADD an...
• Import/Export data wizard in MSSQL 2008 R2 Errors -- Resolved
  on Jan 14, 2014 in sql server sqlserver 2005 SQLserver 2008
  Today I was using the import export wizard to import data from one of the database in the production system to the database in the development system.To do this -- Right click on the database (in the development system) choose -- tasks -- Import data...
• Work Directory in ODBC Connection is empty
  on Dec 22, 2013
   "Work Directory in ODBC Connection is empty, unable to proceed." That was the error I was getting today when I was trying to load a table from MDS using Wherescape Red. At first I didnot understand why there is a work directory needed. W...
• ERROR 22-322: Syntax Error is SAS code
  on Aug 19, 2013 in SAS Code
  I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. Today I was running a SAS program and got the following error. ERROR 22-322: Syntax error, expecting one of...
• Free ebooks from Microsoft
  on Jun 19, 2013 in Sharepoint sqlserver
  Here is a link to a huge collection of free ebooks posted by Eric Ligman from Microsoft.  Hope you will find these books useful in your career development.
• on Feb 3, 2013
  I thought I will start updating my blog after a bit hibernation.So here is a tip for getting rid of the blank page that appears if you use a Next Page After setting in the group section as shown below.Use the formula Not OnlastrecordTo do this click...
• Sql Server Error 3154
  on Jul 12, 2012
  I created a new database today and was wanting to restore this new database from another exisitng database using the restore option available in the wizard.But I got the 3154 error as below.So I had to restore to the restore database command in the S...
• Workbook is larger than the maximum workbook size
  on May 14, 2012
  I use sharepoint 2010 to display the data analysis tool I have created in excel 2010 to manage the Microsoft licenses as well as to utilise the excel 2010 capabilities of slicers and dicers. This has been going pretty smoothly until yesterday when I...
• Scroll Lock problems in Excel
  on Mar 5, 2012 in Excel Excel 2007 Excel 2010
  Yesterday I had this problem in moving between the cells within excel. This problem usually occurs if the scroll lock is on. I tried to find the scroll lock button on my keyboard but it was not there. So I got the idea of using the On screen keyboard...
• Remove the compatibility mode from excel files
  on Mar 1, 2012 in Excel Excel 2007 Excel 2010
  As you all know Excel 2007 has lot more features compared to Excel 2003. The extension with which the excel files are saved alos differs based on the version of excel.For excel 2003 the file is saved as .xls and for Excel 2007 the file is saved as .

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment