Common Table Expression (CTE) Archives

SQL Server Common Table Expression – Creating a Calendar

September 29, 2013September 11, 2014 - by Mridul Chandhok - Leave a Comment

Friends, In this post I am going to discuss, how to retrieve a month’s calendar by passing month and year as parameters to the script or procedure. The important point to …

SQL Server

SQL Server: Find 4,5 and 6 ranked entity

October 19, 2011August 28, 2014 - by Raunak Jhawar - Leave a Comment

Find 4th, 5th and 6th ranked entity Let me first confess. This blog was never a planned effort. It just happened. How it happened…that’s equally interesting. Most of the time you …