Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
sql server 124
sql 123
ms sql server 118
ms sql 117
database 108
tsql 80
#SQL Server 78
t-sql 74
#sql 71
sql server general 66

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
September 2013 5
June 2013 5

CTE inside CTE in SQL Server

Mar 20 2012 12:00AM by Paresh Prajapati   

As per requirement in custom logic we need to require CTE (Common Table Expression) something like for the hierarchy, to find duplicate and remove data or for some other stuff. Recently i have used CTE within CTE for one logic and maxrecursion option as well.  So we will look as how we can use CTE inside CTE or multiple CTEs. Let us create one requirement. The requirement is we need to find the first and second objects by object types in the database and it should be in ascending order. Continue Reading...

Tags: sql, tsql, sql server, ms sql server, t-sql, #SQL Server, #sql, database, sql server general, SQL Scripts, backup, CTE, Common Table Expression

Paresh Prajapati
6 · 23% · 7533
2 Readers found this post to be a life saver
Paresh Prajapati found this post to be a life saver on 3/20/2012 5:18:00 AM
Profile · Blog · Facebook · Twitter
techkrg found this post to be a life saver on 4/8/2012 7:10:00 PM


Your Comment

Sign Up or Login to post a comment.

"CTE inside CTE in SQL Server" rated 5 out of 5 by 9 readers
CTE inside CTE in SQL Server , 5.0 out of 5 based on 9 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]