November 15, 2010 at 6:45 pm
Alvin Ramard (11/15/2010)
WayneS (11/14/2010)
Who all is planning on going to SQL Rally in Orlando in May?I'm definitely going to try to make it to that one, especially after not making it to the summit.
I'd love to go, we honeymooned in Orlando, so I could probably convince wifey to travel with me, but that's too far into the future to be able to say yet.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 15, 2010 at 8:34 pm
jcrawf02 (11/15/2010)
Alvin Ramard (11/15/2010)
WayneS (11/14/2010)
Who all is planning on going to SQL Rally in Orlando in May?I'm definitely going to try to make it to that one, especially after not making it to the summit.
I'd love to go, we honeymooned in Orlando, so I could probably convince wifey to travel with me, but that's too far into the future to be able to say yet.
Really?
Jon: "Wifey, There's a 2 day SQL conference going on in Orlando in May that I'd really like to go to. Whatcha think about taking a week off, and we go down there for a 2nd honeymoon? You go do some of that girly stuff for the two days I'm in the conference, and we'll have a blast for the rest of the week that we're down there!"
Then just make sure buy lots of candles for the nights in the hotel!
IMHO, It seems like a good time to be planning this!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
November 16, 2010 at 1:43 am
Steve Jones - SSC Editor (11/15/2010)
Heard from Barry. He's fine, just busy.
Good news to start the day. Thanks Steve.
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
November 16, 2010 at 1:46 am
Jack Corbett (11/15/2010)
Appreciate the advice coming from y'all on my burn out thread.
Plenty of 20/20 hindsight in there, Jack. Everything you need to know and then some. Take it easy, take a break, take your time. You've been giving for far too long. Best wishes.
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
November 16, 2010 at 6:18 am
Am I being too harsh with this poster?
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
November 16, 2010 at 6:19 am
WayneS (11/15/2010)
jcrawf02 (11/15/2010)
Alvin Ramard (11/15/2010)
WayneS (11/14/2010)
Who all is planning on going to SQL Rally in Orlando in May?I'm definitely going to try to make it to that one, especially after not making it to the summit.
I'd love to go, we honeymooned in Orlando, so I could probably convince wifey to travel with me, but that's too far into the future to be able to say yet.
Really?
Jon: "Wifey, There's a 2 day SQL conference going on in Orlando in May that I'd really like to go to. Whatcha think about taking a week off, and we go down there for a 2nd honeymoon? You go do some of that girly stuff for the two days I'm in the conference, and we'll have a blast for the rest of the week that we're down there!"
Then just make sure buy lots of candles for the nights in the hotel!
IMHO, It seems like a good time to be planning this!
yeah, well personal stuff that will dictate whether we can or can't travel at that time, and if it's in the budget.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 16, 2010 at 6:33 am
Chris Morris-439714 (11/16/2010)
Am I being too harsh with this poster?
You are the very model of self-restraint.
November 16, 2010 at 6:36 am
Paul White NZ (11/16/2010)
Chris Morris-439714 (11/16/2010)
Am I being too harsh with this poster?You are the very model of self-restraint.
I never know when to take you seriously Paul, even when there's a shiny bit of code visible 😛
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
November 16, 2010 at 6:45 am
Chris Morris-439714 (11/16/2010)
I never know when to take you seriously Paul, even when there's a shiny bit of code visible 😛
That must be really irritating.
November 16, 2010 at 6:51 am
Paul White NZ (11/16/2010)
Chris Morris-439714 (11/16/2010)
I never know when to take you seriously Paul, even when there's a shiny bit of code visible 😛That must be really irritating.
Only on tuesday afternoons.
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
November 16, 2010 at 6:54 am
Chris Morris-439714 (11/16/2010)
Jack Corbett (11/15/2010)
Appreciate the advice coming from y'all on my burn out thread.Plenty of 20/20 hindsight in there, Jack. Everything you need to know and then some. Take it easy, take a break, take your time. You've been giving for far too long. Best wishes.
Thanks. I don't know that I've been giving for too long, but I do need to refine my focus a little bit.
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
November 16, 2010 at 6:58 am
Chris Morris-439714 (11/16/2010)
Only on tuesday afternoons.
Hah! No, seriously then, I would have given up on that thread a good while ago. Not eager to help himself is he?
November 16, 2010 at 7:04 am
Paul White NZ (11/16/2010)
Hah! No, seriously then, I would have given up on that thread a good while ago. Not eager to help himself is he?
Some of his replies are almost childlike in their awkwardness. It's the language thing which worries me though. Pidgin goes in pies, not on boards.
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
November 16, 2010 at 7:06 am
Jack Corbett (11/16/2010)
Thanks. I don't know that I've been giving for too long, but I do need to refine my focus a little bit.
SQL Server is an entirely bewildering product these days.
November 16, 2010 at 8:36 am
Chris Morris-439714 (11/16/2010)
Am I being too harsh with this poster?
I'd say that you've been overly patient. OP has posted the sample data numerous times in a completely unusable format, and you're just asking for them to post it in a better way. Nothing harsh.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 15 posts - 21,481 through 21,495 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply