What makes a CTE different from a Derived Table/Subquery? When to use it?

by Rohit 23. November 2013 23:30
Common Table Expression (CTE) was introduced in SQL Server 2005. A CTE is a temporary result set similar to a derived table which is not stored as an object. This result set lasts only for the duratio... [More]

Tags: , , ,

SQL Server | Technology

SQL Server Day Photos - October 26 2013, Microsoft Bangalore

by Rohit 26. October 2013 11:41
Like US, in India we don't have that many communities and live events. When I moved to Bangalore an year back, I searched for .NET and SQL Server user groups in Bangalore. Few .NET user groups exist b... [More]

Tags: ,

Blog | Life | SQL Server

SQL Server: Get week start and end dates of any month

by Rohit 19. January 2013 13:38
Get week start dates of any month DECLARE @startDate DATETIME SET @StartDate = '20130101' ;WITH DayCounter(n) AS ( SELECT 0 UNION ALL SELECT n+1 FROM DayCounter WHERE n<30) SELECT DISTINCT Dat... [More]

Tags: , ,

SQL Server | Technology

About Rohit Prakash

Software Craftsman @ Fortune 100 Company. Technical Reviewer of few programming books.

A Single, Writer, Reader and Adventurist.

You can reach me at:

rohit [at] irohitable.com

-----------------------------------------

LinkedIn:

in.linkedin.com/in/rohitpkhare

Twitter:

@BuzzRohit

-----------------------------------------

Month List

Protected by Copyscape Web Plagiarism Software