March 4, 2009 at 6:53 am
GilaMonster (3/4/2009)
19 threads in total (including the Answered posts one), mostly a single post per thread. Ok solutions, little explanation and once or twice a link to the person's blog.
... containing several examples of how to do running totals with a triangular join π
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 4, 2009 at 6:56 am
Can I just add that I think this is the first time I've seen an active blanket party on this site. This poor guy sure did pick a fight, if unintentionally.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 4, 2009 at 6:57 am
Grant Fritchey (3/4/2009)
Chris Morris (3/4/2009)
Wipe yer eyes mate, here's a Fuller's ESB, probably the best beer in the world.Ooohhh... Beer! And an ESB. I'm happy again. Cheers!
Welcome! ...you're not going to ask the business reason then? π
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 4, 2009 at 7:03 am
Lynn Pettis (3/4/2009)
And then you have this. I don't think the desert is big enough to hide in anymore.And, am I still Saint?
Did that post get removed? I tried the link and it's showing an error. I'd just like to know what happened out of a morbid sense of curiosity.
-- Kit
March 4, 2009 at 7:03 am
GilaMonster (3/4/2009)
Jack Corbett (3/4/2009)
The funny thing is I don't ever recall seeing the name on any other posts.19 threads in total (including the Answered posts one), mostly a single post per thread. Ok solutions, little explanation and once or twice a link to the person's blog.
Yeah, I took the time (about 1 minute) to peruse the posts. I was going to "call him out" on the other thread about his lack of explanation for his answers, but chose what I like to think is the high road, by just mentioning that when I post code I try to offer an explanation as well.
At least he is getting my post count up:w00t:
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 4, 2009 at 7:04 am
Lynn Pettis (3/4/2009)
And then you have this. I don't think the desert is big enough to hide in anymore.And, am I still Saint?
The link doesn't appear to go anywhere. Has that thread been deleted, or am I missing something?
Edit: Never mind. I found it.
http://www.sqlservercentral.com/Forums/Topic668144-4-1.aspx
and
http://www.sqlservercentral.com/Forums/Topic666402-4-1.aspx
(There I go, violating that "just posts some links" thing again!)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 4, 2009 at 7:05 am
Grant Fritchey (3/4/2009)
Can I just add that I think this is the first time I've seen an active blanket party on this site.
I've seen one before. Happened when one guy swore at me (literally) for making a suggestion. He posted after I went to bed and by next morning there were almost 20 posts by other people in defence.
Looked very much like this one, just less polite, with the guy convinced he was in the right.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 7:07 am
GSquared (3/4/2009)
Has that thread been deleted?
Not yet
http://www.sqlservercentral.com/Forums/Topic666402-4-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 7:10 am
Lynn Pettis (3/4/2009)
And, am I still Saint?
Lynn, always! And then some.
As far as the link, it was available about 15 minutes ago, as I posted a reply. Perhaps Steve disabled/deleted it??
-- You can't be late until you show up.
March 4, 2009 at 7:11 am
GSquared (3/4/2009)
Lynn Pettis (3/4/2009)
And then you have this. I don't think the desert is big enough to hide in anymore.And, am I still Saint?
The link doesn't appear to go anywhere. Has that thread been deleted, or am I missing something?
The link was to a specific post and, yes it was deleted but you can still read it as I quoted it in a reply.
I have fixed the link in my original post to that thread.
March 4, 2009 at 7:13 am
Chris Morris (3/4/2009)
..you're not going to ask the business reason then? π
Free beer means no questions asked.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2009 at 7:32 am
Looks like Mangal deleted some of his posts as they are only now recorded in the quotes other posters used. Perhaps he realized he had landed himself in a pool of sharks very willing to defend our most helpful posters?
Keep up the good work guys (and gals) and don't let one idiot drag you down to his level, cause it's not very pleasant down there. π
And come to THE THREAD to vent. :w00t:
-- Kit
March 4, 2009 at 7:37 am
Chris Morris (3/4/2009)
Welcome! ...you're not going to ask the business reason then? π
Question a free beer? Surely that way lies madness.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 4, 2009 at 7:40 am
GilaMonster (3/4/2009)
I've seen one before. Happened when one guy swore at me (literally) for making a suggestion. He posted after I went to bed and by next morning there were almost 20 posts by other people in defence.Looked very much like this one, just less polite, with the guy convinced he was in the right.
Oooh, I'm sorry I missed it. I never get to use any of my favorite four letter words.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 4, 2009 at 7:41 am
Lynn Pettis (3/4/2009)
GSquared (3/4/2009)
Lynn Pettis (3/4/2009)
And then you have this. I don't think the desert is big enough to hide in anymore.And, am I still Saint?
The link doesn't appear to go anywhere. Has that thread been deleted, or am I missing something?
The link was to a specific post and, yes it was deleted but you can still read it as I quoted it in a reply.
I have fixed the link in my original post to that thread.
Actually, it looks like he deleted most of his posts from that thread and started a new one with an identical post here because the first one was giving him a headache.
Derek
Viewing 15 posts - 2,161 through 2,175 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply