RBarryYoung

Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 7,636 total)

RE: Create Auto Number based on ORder by Field

arun_anand09 (4/16/2009)
But the above does not like ORder By statement,.
Could you clarify what you mean by this statement?

April 16, 2009 at 8:13 am

#978879
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

peter (4/16/2009)
...
my take on the format of the article
For me the introduction was too longwinded and in the end not really to the point.
Then I am not sure...

April 16, 2009 at 8:06 am

#978862
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Jeff Moden (4/16/2009)
Mr. Young... very nice job. Immensely entertaining article and follow up posts to boot. My hat is off to you, Sir... I know just what you're...

April 16, 2009 at 7:07 am

#978781
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Jeff Moden (4/16/2009)
...
For those who don't know what a "pseudo-cursor" is, here's one of the simplest answers I can give...
SELECT columnlist
FROM sometable
Think about what that little...

April 16, 2009 at 7:05 am

#978774
RE: Are the posted questions getting worse?

IIRC, ASCII was originally a separate standards organization (probably sponsored by the federal government) , that was later subsumed by ANSI. It may very well have been the first...

April 16, 2009 at 6:54 am

#978765
RE: Are the posted questions getting worse?

So tired... Answered ... so many ... posts... must get... sleep. then answer... more posts... zzzzzzzzzzzzzz...

April 16, 2009 at 12:06 am

#978614
RE: Reference 'Deleted' table: Dynamic SQL

AFAIK, there's nothing like a global trigger.

April 15, 2009 at 11:49 pm

#978610
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Thomas (4/15/2009)
Oh, and as it turns out I didn't waste ANY hours coming up with this one. In fact it took me less than a minute. That's because...

April 15, 2009 at 11:42 pm

#978609
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Thomas (4/15/2009)
Yep. I agree. However, recognize that we are again having to find alternative solutions because the base set based solution is insufficient.
Some clarification may be in order here. ...

April 15, 2009 at 11:04 pm

#978604
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Thomas (4/15/2009)
RBarryYoung (4/15/2009)
That said, it should be noted that there are also other ways to accomplish the same thing that do not use cursors.
Agreed and almost all of those solutions...

April 15, 2009 at 10:56 pm

#978603
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

RBarryYoung (4/15/2009)
Thomas (4/14/2009)
Agreed. Here's another example. You want to build a numbers table that simply contains a series of sequential integers. There are many uses for such a table in...

April 15, 2009 at 10:34 pm

#978595
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Andy DBA (4/15/2009)
I apologize if this is somewhat off topic and there's probably tons of articles on it already, but here is a word to the wise on performance testing....

April 15, 2009 at 10:16 pm

#978592
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Andy DBA (4/15/2009)
So, getting back to my question, what I'm driving at is that using aggregated dynamic sql to call an sp multiple times (instead of a loop) requires more...

April 15, 2009 at 9:47 pm

#978583
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

john.arnott (4/15/2009)
Dejan,
This is a classic example of how powerful the row_number() function can be. I coded this solution using a CTE out of personal preference, although I suppose that...

April 15, 2009 at 9:22 pm

#978572
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

dejan.kelemen (4/15/2009)
I'm all for declarative and rarely or almost never use while loops or cursors, but how would I go about doing this without while loop...btw I'm writing this in...

April 15, 2009 at 9:17 pm

#978571

Viewing 15 posts - 2,866 through 2,880 (of 7,636 total)