A central place for all my learning in the Information Technology field
Owner: indupriya
Listed in: Technology
Language: English
Tags: sqlserver, photoshop, css, javascript, web design
Site Statistics
Unique Visitors Today:
3
Page Views Today:
4
Unique Visitors this Week:
3
Page Views this Week:
4
Unique Visitors this Month:
83
Page Views this Month:
85
Total Unique Visitors:
37,290
Total Page Views:
41,859
Total Hits Out:
270
Latest Blog Posts for My Tech Learning
- Getting the first date of the month in SQL without any functionson Feb 25, 2014 in SQLOne 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 -- ResolvedToday 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 emptyon 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 codeon Aug 19, 2013 in SAS CodeI 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 Microsofton Jun 19, 2013 in Sharepoint sqlserverHere 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, 2013I 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 3154on Jul 12, 2012I 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 sizeon May 14, 2012I 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 ExcelYesterday 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 filesAs 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 .
Loading Comments...
Comments
{ds_PageTotalItemCount} commentcomments
{pvComments::date}
{pvComments::comment}