<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>
Content with tags
T-SQL
,
Recursion
,
CTE
Items 1 to 7 of 7
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,635 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,742 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,966 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
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,311 reads
Riddle Me This
Read more...
By
Jason Brimhall
2009/12/21
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,690 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,966 reads
Items 1 to 7 of 7
Tags
ema
(1)
holiday
(1)
humor
(1)
macd
(1)
moving average
(1)
sma
(1)
string manipulation
(1)
tally table
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
