December 22, 2009 at 7:59 pm
The Dixie Flatline (12/22/2009)
Bring forth the Holy Pork Chop of Antioch! 😛
Heh... paraphrased from one of my favorite "B" movies...
"Glory be to the [Code], and to the Holy [Forum]. As it was in the beginning, is now, and ever shall be. [T-SQL questions] without end. Amen."
--Jeff Moden
Change is inevitable... Change for the better is not.
December 22, 2009 at 11:00 pm
Jeff Moden (12/22/2009)
CirquedeSQLeil (12/22/2009)
Jeff Moden (12/22/2009)
CirquedeSQLeil (12/22/2009)
...And chastising QODs:blush:Heh... nah... "tweeking" is the word that I would chose on the one you're thinking of. 😀 I bashed one that Steve posted pretty darned hard.... that was a "2 chop chastisment".
I totally expected somebody to do it better. It was no surprise to see it. I just wanted to demonstrate a little "fun" on my birthday. A little demo on forward and backward types of recursion.
I did like your script.
Heh... and to calm the other fears that you spoke of in a PM... only those that study your good code example will actually realize the power of the "gen" code you used. If they do, they deserve the knowledge that you've bestowed upon them. Well done, Jason.
Thanks much kind Sir:cool:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 23, 2009 at 2:21 am
john.arnott (12/22/2009)
Lynn Pettis (12/22/2009)
I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing that trend?(Okay, two posts don't make a trend, but it could be the start ... 😛 )
I think it's a natural assumption for folks who've just started using a relational db. If they've used Excel, for instance, it may be even more difficult to realize the difference between db tables and spreadsheets.
Anyway, Merry Christmas/Happy Chanukah/Peaceful Ramadan/Happy Kwanza to all!
That's an interesting point you make, John. Someone here was recently asking why I'd added an extra column at column A in a spreadsheet they'd sent me. I've been doing it for years now, add a new column A as an identity column - it's because the sort order of rows in a spreadsheet is often very meaningful and it's almost always impossible to sort it back once you've sorted it to a different order, you have to copy or whatever. An "identity column" changes all that.
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
December 23, 2009 at 8:13 am
I am still around, been a bit busy working on an article. I want to finish it off before the year ends. But I am not going to touch the article on 24th, 25th and 26th. Or else I probably will have to sleep in the lawn...:-D Kids and wifey will kick me out...:-)
Which part of south India are you from Bru?
-Roy
December 23, 2009 at 10:41 am
Today is the 23rd, and several we know are on vacation.
So, who is really working??
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 23, 2009 at 10:54 am
*raises hand* and it's 8pm here.
I'm days behind where I should be on the current project, partially because of lots of VM problems.
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
December 23, 2009 at 11:02 am
I am working...Tomorrow I am OFF. Monday I will be back to work till Wednesday. Then I am off again. After that it will be in New Year I will be back.. 🙂 Hoping to take my kid fishing this weekend. It is still warm and sunny here... 😀
-Roy
December 23, 2009 at 11:04 am
CirquedeSQLeil (12/23/2009)
Today is the 23rd, and several we know are on vacation.So, who is really working??
1 PM here. Still working. 4-day weekend starts tomorrow. Might sneak out early today, but gotta ask my boss first.
- 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
December 23, 2009 at 11:04 am
December 23, 2009 at 11:06 am
10 am here - and not seeing a rousing response about work.
Next question is: Who has mentally checked out for the holidays?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 23, 2009 at 11:07 am
ME Me Me.....:-D I have been in a holiday mood from 7th onwards. That was the first party. Went home the next day at 5 AM.... 😀 Pasted as usual...:hehe:
-Roy
December 23, 2009 at 11:10 am
CirquedeSQLeil (12/23/2009)
Next question is: Who has mentally checked out for the holidays?
*raises hand*
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
December 23, 2009 at 11:11 am
Roy Ernest (12/23/2009)
I am working...Tomorrow I am OFF. Monday I will be back to work till Wednesday. Then I am off again. After that it will be in New Year I will be back.. 🙂 Hoping to take my kid fishing this weekend. It is still warm and sunny here... 😀
Sorry - just hit the lunch hour. I am still working today.....
(by the way - there seems to be a bug going on. No matter which message I pick to reply to, Roy's message is the one that gets quoted.... - See above. I had picked Gus' message to reply to).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
December 23, 2009 at 11:14 am
CirquedeSQLeil (12/23/2009)
10 am here - and not seeing a rousing response about work.Next question is: Who has mentally checked out for the holidays?
Yup. It actually started Monday afternoon, although I was sick yesterday (not just sick of work)
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
December 23, 2009 at 11:18 am
Matt Miller (#4) (12/23/2009)
Roy Ernest (12/23/2009)
I am working...Tomorrow I am OFF. Monday I will be back to work till Wednesday. Then I am off again. After that it will be in New Year I will be back.. 🙂 Hoping to take my kid fishing this weekend. It is still warm and sunny here... 😀Sorry - just hit the lunch hour. I am still working today.....
(by the way - there seems to be a bug going on. No matter which message I pick to reply to, Roy's message is the one that gets quoted.... - See above. I had picked Gus' message to reply to).
It's a known bug. If you hit the Quote button, and someone has posted something since you got to the page, it will pick a prior post to quote, not the one you selected.
The solution is refresh the page and try again. If there are a lot of fast responses on the page, it may take multiple tries.
- 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
Viewing 15 posts - 10,276 through 10,290 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply