Monthly Archives: June 2016

Drill Down SQL Query

SQL Server does not provide any drill down queries such as Category > Sub Category. There are reporting tools for it but it cannot be done in SQL Query alone without help from theird party software. There is SQL Group … Continue reading

Posted in SQL Server 2008 | Leave a comment

How to give names to group sets in SQL

You have a group set query in SQL that you are using to give sum total of certain numbers. The problem is where the row calculates the sum total, the cell values in the corresponding colums say ‘NULL’. How to … Continue reading

Posted in SQL Server 2008 | Tagged , | Leave a comment

The type of column “xxx” conflicts with the type of other columns specified in the UNPIVOT list.

When pivoting data in SQL Server, all columns must be of same time, otherwise you will get this error. You might get this error if you have imperfect case statement or one column is of integer type while the other … Continue reading

Posted in SQL Server 2008 | Tagged , | Leave a comment

cannot find stored procedure SQL Server

I was creating a stored procedure on my live server and was constantly getting the error message “Cannot find stored procedure” no matter how many times i created the same stored procedure on the server. Worse if I would create … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Visual Studio 2015 stuck at Windows Update KB2999226

I had installed Visual Studio 2005 community version on a Windows laptop before and it went all good but this time when I installed it on macbook pro (Windows 7), it got stuck the Windows Update KB2999226. I waited for … Continue reading

Posted in Uncategorized | 2 Comments

Reasons why the rumoured specs of macbook 2016 could be wrong

Cult of Mac has published rumored pics of macbook pro 2016 that should top view, front and side views. The rumoured specs are It will have OLED touch panel for function keys Will have 4 USB-C ports (no standard USB … Continue reading

Posted in Uncategorized | Leave a comment