<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Articles with tag
CTE
Search for
any
content tagged
cte
Items 1 to 14 of 14
Exploring Recursive CTEs by Example
Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.
Read more...
By
Dwain Camps
2012/07/17
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
10,646 reads
Pros and cons of six SQL table tools
This article shows how to use 6 SQL table-based tools to solve the same problem, and gives the pros and cons of each.
Read more...
By
Andy Owl
2011/12/26
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
8,559 reads
Dealing with Incomplete Data - A T-SQL Puzzle 1
Client data received for processing may have invalid records based on processing requirements. Identifying and dealing with bad records in a specific scenario is the object of this article.
Read more...
By
Suresh Maganti
2011/11/22
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
3,285 reads
Calculating Stock Returns Using the ROW_NUMBER function and CTEs
In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.
Read more...
By
John Ryle
2011/10/18
|
Source:
SQLServerCentral.com
|
Category:
common table expressions
Rating:
|
Discuss
|
Briefcase
|
5,232 reads
Hidden RBAR: Counting with Recursive CTE's
"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.
Read more...
By
Jeff Moden
2011/08/08
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
9,750 reads
Displaying Sorted Hierarchies (SQL Spackle)
Learn how you can query a hierarchy of data and also return the results in an ordered fashion. A handy T-SQL skill that you will use over and over again.
Read more...
By
Jeff Moden
2011/03/10
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
10,343 reads
Concatenating Rows
Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.
Read more...
By
Carl P. Anderson
2011/03/04 (first published: 2009/10/14)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
146,974 reads
Common table expressions and circular references
Finding circular references that are stopping your CTE from working.
Read more...
By
Geoff Norman
2011/01/31
|
Source:
SQLServerCentral.com
|
Category:
cte
Rating:
|
Discuss
|
Briefcase
|
8,968 reads
How to Compare Rows within Partitioned Sets to Find Overlapping Dates
How to Compare Rows within Partitioned Sets to Find Overlapping, Contiguous, or Gap dates
Read more...
By
Kevin Wu
2010/10/11
|
Source:
SQLServerCentral.com
|
Category:
cte
Rating:
|
Discuss
|
Briefcase
|
5,152 reads
An Urgent Ad Hoc Report
In this new article, Yakov Shlafman shows us how he wrote a quick ad hoc report of expenses so that he could leave on time one day.
Read more...
By
Yakov Shlafman
2010/03/17
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
8,022 reads
Calculating Moving Averages with T-SQL
How to efficiently calculate moving averages with SQL Server using Stock Market data.
Read more...
By
Gabriel Priester
2010/03/04
|
Source:
SQLServerCentral.com
|
Category:
moving average
Rating:
|
Discuss
|
Briefcase
|
14,326 reads
Convert String to a Table using CTE
Explains how to convert a list of Ids passed as string and convert it to a table
Read more...
By
Amit Gaur
2009/12/14
|
Source:
SQLServerCentral.com
|
Category:
cte
Rating:
|
Discuss
|
Briefcase
|
12,671 reads
Concatenating Rows
Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.
Read more...
By
Carl P. Anderson
2011/03/04 (first published: 2009/10/14)
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
146,974 reads
The Dynamic Tally or Numbers Table
Building a tally table is a common T-SQL problem that many new developers struggle with. Lynn Pettis brings us an article that shows how to use CTEs to accomplish this.
Read more...
By
Lynn Pettis
2009/09/22
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
9,016 reads
Items 1 to 14 of 14
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
