T-SQL Cursor Puzzle

Question

T-SQL Cursor Puzzle

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 1

Jeff Moden (3/4/2011)
As a side bar, Lutz, CC and I make one hell of a tag team with no sense of "one-up-manship". It would be a joy to work with them on a project in real life. :w00t:

WOW.. this probably is the best honor i had ever had i my life 🙂 I would be very very happy to tag up with you legends and work! Thanks Jeff, you probably made my month 🙂 :blush:

LutzM (3/4/2011)
Regarding the tag team: that would simply be AWESOME!!!!
Unfortunately, there's an ocean in between. But who knows... things may change... (I'm not talking about a massive continent movement though 😉 )

Hmmm, yeah , Lutz ; But i and Jeff can meet as we are in the same continent 🙂 I am in the US for an assignment. I am in Seattle, WA right now 🙂 Looking forward for a chance to meet Jeff or WayneS and others who are here 🙂

WayneS SSC Guru Points: 95461 More actions · Answer 2

Jeff Moden (3/4/2011)
Thank you very much for the feedback... but Lutz set the stage to avoid RBAR using some very high performance code. All I did was tweek his code. 🙂
As a side bar, Lutz, CC and I make one hell of a tag team with no sense of "one-up-manship". It would be a joy to work with them on a project in real life. :w00t:

You know, I see nothing wrong with a little bit of "one-up-manship" - if you think about it, it's kinda how all of us learn the better performing ways. The big thing is that is that there isn't any bragging about it going on.

And, maybe this is what you meant...

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

LutzM SSC Guru Points: 107049 More actions · Answer 3

ColdCoffee (3/4/2011)
...
Hmmm, yeah , Lutz ; But i and Jeff can meet as we are in the same continent 🙂 I am in the US for an assignment. I am in Seattle, WA right now 🙂 Looking forward for a chance to meet Jeff or WayneS and others who are here 🙂

So you're not from the U.S. then? Did I miss something?

@ktisat: I'm sorry for hijacking your thread with a rather non-related topic...

But as you may have noticed, SSC is not just a forum like others. It's at least a great community, if not a family. And this may lead to discussions aside...

Again, sorry about it, and at the same time: welcome aboard!!

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 4

LutzM (3/5/2011)
ColdCoffee (3/4/2011)
...
Hmmm, yeah , Lutz ; But i and Jeff can meet as we are in the same continent 🙂 I am in the US for an assignment. I am in Seattle, WA right now 🙂 Looking forward for a chance to meet Jeff or WayneS and others who are here 🙂
So you're not from the U.S. then? Did I miss something?

No,Lutz. Am basically from India, have come here to the US as an analyst 🙂

But hey, my transit flight to Seattle was from Frankfurt, so i touched ur continent as well :w00t:

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 5

WayneS (3/4/2011)
Jeff Moden (3/4/2011)
Thank you very much for the feedback... but Lutz set the stage to avoid RBAR using some very high performance code. All I did was tweek his code. 🙂
As a side bar, Lutz, CC and I make one hell of a tag team with no sense of "one-up-manship". It would be a joy to work with them on a project in real life. :w00t:
You know, I see nothing wrong with a little bit of "one-up-manship" - if you think about it, it's kinda how all of us learn the better performing ways. The big thing is that is that there isn't any bragging about it going on.
And, maybe this is what you meant...

Yep.. That's what I meant, Wayne. Yes, we many times add to or correct someone else's code but the regulars never make "in-your-face-sucka" comments to each other. As you say, it's all a manner of learning and trading skills and ideas. 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 6

ColdCoffee (3/4/2011)
Jeff Moden (3/4/2011)
As a side bar, Lutz, CC and I make one hell of a tag team with no sense of "one-up-manship". It would be a joy to work with them on a project in real life. :w00t:
WOW.. this probably is the best honor i had ever had i my life 🙂 I would be very very happy to tag up with you legends and work! Thanks Jeff, you probably made my month 🙂 :blush:
LutzM (3/4/2011)
Regarding the tag team: that would simply be AWESOME!!!!
Unfortunately, there's an ocean in between. But who knows... things may change... (I'm not talking about a massive continent movement though 😉 )
Hmmm, yeah , Lutz ; But i and Jeff can meet as we are in the same continent 🙂 I am in the US for an assignment. I am in Seattle, WA right now 🙂 Looking forward for a chance to meet Jeff or WayneS and others who are here 🙂

I'm afraid there's little chance of us getting together during your stay in the U.S., Cold Coffee. I live more than 2,300 miles (near Detroit, Mi) to the East of Seattle.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)