<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>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Jeff Moden
»
Hidden RBAR: Counting with Recursive CTE's
69 posts, Page 7 of 7
««
«
3
4
5
6
7
Hidden RBAR: Counting with Recursive CTE's
Rate Topic
Display Mode
Topic Options
Author
Message
Jeff Moden
Jeff Moden
Posted Wednesday, August 10, 2011 6:31 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
Jon Russell (8/10/2011)
As usual, excellent! Thanks, Jeff.
You bet, Jon. Thanks for stopping by and for the feedback.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1158150
lstrashnoy
lstrashnoy
Posted Wednesday, August 10, 2011 6:34 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, April 25, 2013 2:10 PM
Points: 6,
Visits: 17
No, I use custom stored function for that purpose.
-Leonard
Post #1158151
Bill Kline-270970
Bill Kline-270970
Posted Thursday, August 11, 2011 1:58 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 9:51 AM
Points: 168,
Visits: 673
Excellent article. A great example of why I come to SQLServerCentral.com . . . to learn from the best.
Post #1158787
Kenney Hill
Kenney Hill
Posted Thursday, August 11, 2011 10:37 PM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, May 30, 2013 9:34 AM
Points: 299,
Visits: 113
Jeff Moden (8/10/2011)
Paul Herbert (8/10/2011)
As usual a good article Moden.
A minor correction if you don't mind. If you are going to quote my 'Really?!", I think it needs both a question mark & an exclamation point. That way it reads like I say it ... a touch of amusement & a ton of WTF. :)
Everyone... please meet and greet Mr. Paul Herbert... the Systems DBA where I work at. We've slain many dragons together in the short year or so that we've had the opportunity to work with each other.
I've been trying to convince him to write an article about some of the things he's done on the Administrative side of the world. Maybe you good folks can help me convince him.
Welcome Paul!
I'd really be interested in an administrative article by you. The administrative side is my primary SQL job focus, but I know there are so many things that I could set-up better on that side.
Plus you could always let slip something embarrassing or funny or both about Jeff in the article!
Post #1158962
Jeff Moden
Jeff Moden
Posted Friday, August 12, 2011 6:18 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
Bill Kline-270970 (8/11/2011)
Excellent article. A great example of why I come to SQLServerCentral.com . . . to learn from the best.
Thanks, Bill.
I really appreciate the compliment but, gosh no... I'm not in "the best" category. There are plenty of folks that are much better at this than I. I just try really hard to keep up with all of them.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1159129
Jeff Moden
Jeff Moden
Posted Friday, August 12, 2011 6:20 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
Kenney Hill (8/11/2011)
Plus you could always let slip something embarrassing or funny or both about Jeff in the article!
Heh... the fact that I talk with the dust bunnies isn't bad enough?
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1159131
David Burrows
David Burrows
Posted Friday, August 19, 2011 5:01 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:30 AM
Points: 6,380,
Visits: 5,432
Another great article Jeff
Jeff Moden (8/8/2011)
... some would say that I, indeed, have no taste buds
Surely you meant 'no taste'
Far away is close at hand in the images of elsewhere.
Anon.
Post #1162367
Jeff Moden
Jeff Moden
Posted Friday, August 19, 2011 2:07 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
David Burrows (8/19/2011)
Another great article Jeff
Jeff Moden (8/8/2011)
... some would say that I, indeed, have no taste buds
Surely you meant 'no taste'
heh... that, too! And don't call me "Shirley".
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1162754
Gullimeel
Gullimeel
Posted Tuesday, May 15, 2012 9:13 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, January 17, 2013 1:46 AM
Points: 231,
Visits: 505
Nice article...
Using tally( or numbers table) is best way..Easy to code :).
GulliMeel
Finding top n Worst Performing queries
Improve the performance of Merge Join(special case)
How to Post Performance Problem -Gail Shaw
Post #1300344
« Prev Topic
|
Next Topic »
69 posts, Page 7 of 7
««
«
3
4
5
6
7
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
