Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,456 through 52,470 (of 59,098 total)

RE: Limiting the number of rows returned from a cursor

trigonom (2/13/2008)
I am working in SQL Server 2000.
For testing purposes, how can I limit the number of rows returned from a cursor?
You didn't answer the question that came up right...
--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)

February 19, 2008 at 3:03 pm

#779959
RE: Help with Cursor

Hmmm... I see what you want to do... this is just a small example... if you really want commas in your final output, see where I marked the code "Modify...
--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)

February 19, 2008 at 3:00 pm

#779958
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Christopher Ford (2/19/2008)
BTW, on a production test.
I had to run Jeff's running total update because I had 80 million rows to group by 1,928,672 different accounts over a 7 year...
--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)

February 19, 2008 at 2:40 pm

#779946
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Actually, Kevin, what you said is spot on... but they haven't figured out the rest of what you said, yet... when they do, Michigan will be a hot spot for...
--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)

February 19, 2008 at 11:43 am

#779860
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Christopher Ford (2/19/2008)
Kinda like finding chicken's teeth and my chicken just flew away to a different state.
Eh.... What? :blink:
---
Frank & Kevin both bring up some very valid points though...
--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)

February 19, 2008 at 11:33 am

#779854
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

TheSQLGuru (2/19/2008)
Can't say I agree with that title. Just did a first visit at a new client last week for a performance review. They had a relatively new...
--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)

February 19, 2008 at 11:16 am

#779848
RE: Questions to ask of a new application vendor

Heh... not quite that "whipped"... I've been offered the chance to do a remote thing... just not sure I want to... they pretty much put the screws to about 350...
--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)

February 19, 2008 at 11:02 am

#779841
RE: differiniate quotes as data vs quotes as column identifier

Sure, Bob... If you know how to use a format file, you're well ahead of the game...
Take a look at the example data you gave...
1234, "some data here", "John "jack"...
--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)

February 19, 2008 at 10:56 am

#779839
RE: Show data upto 2 decimal places but with exact values

You bet, Sengar... thank you for the feedback.
It would be interesting to know, though... just why do you need to force a format of 2 decimal places with truncation instead...
--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)

February 19, 2008 at 10:32 am

#779828
RE: code to find the latest file in a folder and load data to a table

Try this... no "SA" privs required...
EXEC Master.dbo.xp_Dirtree 'C:\',1,1
... can be loaded into a table and filtered for use with something like BULK INSERT. Only advantage over what Doug posted...
--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)

February 19, 2008 at 10:28 am

#779825
RE: Fill Factor clarification

Now, that's the way I like to see an article... "Alice's Restaurant" style... full of actual tests with "circles and arrows and a paragraph on the back".
--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)

February 19, 2008 at 10:19 am

#779817
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Heh... LMAO! Now that's funny, Chris! Ya know... I bet it would sell like hotcakes with a title like that!
--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)

February 19, 2008 at 9:59 am

#779805
RE: Questions to ask of a new application vendor

With some great mixed feelings, I won't be joining my outfit in NC... the love of my life for the last 22 years has followed me a couple of times......
--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)

February 19, 2008 at 9:54 am

#779800
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

I have fooled around with some UDF replacements such as calculating
date ranges, .... and I've been amazed how fast this works on CLR.
I'd be real interested in knowing what kind...
--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)

February 19, 2008 at 9:46 am

#779793
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Christopher Ford (2/18/2008)
BTW, wouldn't the RowID go increasing by date in this test case?
98% of the time, you wouldn't run into a situation where RowID 9876 is an earlier date...
--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)

February 19, 2008 at 9:42 am

#779790

Viewing 15 posts - 52,456 through 52,470 (of 59,098 total)