Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,426 through 52,440 (of 59,072 total)

RE: plz help me urgent regd Warning 0x8020200f: Data Flow Task: There is a partial row at the end of the file.

What was the error... partial file transmission or just a bad row or maybe a rowcount at the end of the file? What was the error?
--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 8:18 pm

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

Awesome. And very simple, to boot! Thanks Chris! Neat redirection trick.
--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 8:14 pm

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

Very cool, Chris... how the heck did you do it?
--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 8:10 pm

#780032
RE: plz help me urgent regd Warning 0x8020200f: Data Flow Task: There is a partial row at the end of the file.

... just a reminder... no privacy info, please. Also, if it's a big file, please zip it. Thanks.
--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:13 pm

#779967
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

Viewing 15 posts - 52,426 through 52,440 (of 59,072 total)