Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,746 through 32,760 (of 59,099 total)

RE: import flat file through SSIS

It would appear that each of those example lines has a trailing space. Is that true or just a "paste" anomoly?
--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)

August 24, 2011 at 7:51 pm

#1372924
RE: import flat file through SSIS

I just took a look at your BCP format file... it seems wicked complicated for what we need to do according to the format you explained to look like the...
--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)

August 24, 2011 at 7:49 pm

#1372923
RE: Automatic XML

Very cool. Thanks for taking the time to write that up, Matt. It keeps me interested in learning more about XML.
--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)

August 24, 2011 at 7:43 pm

#1372922
RE: Count Number of rows added within a certain time period

Greg,
Did Lutz's answer do it for you?
--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)

August 24, 2011 at 7:13 pm

#1372918
RE: Finding it impossible to Split a column based on a delimiter

Evil Kraig F (8/22/2011)
Jeff Moden (8/18/2011)
I would just pork chop the provider of the spreadsheet and get them to do things right. 😉
The problem here isn't the providers, it's...
--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)

August 24, 2011 at 7:09 pm

#1372917
RE: import flat file through SSIS

I sure am sorry. :blush: I lost track of this post. Are you all set or do you still need help?
--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)

August 24, 2011 at 6:56 pm

#1372915
RE: How to import multiple CSV files.

Sorry... lost track of this post.
Maybe, maybe not. "It Depends" on how the VB is written. But, personally, I'd rather just use the xp_DirTree thing because if I can...
--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)

August 24, 2011 at 6:54 pm

#1372914
RE: Improving Delete Performance

"Sub-second" is a purdy word, Jack. Thanks for the feedback on what you ended up doing.
--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)

August 24, 2011 at 6:49 pm

#1372912
RE: Removing redundant information

doug 40899 (8/23/2011)
Leaving me with the one line on the bottom as my only "true" return. ([font="Arial Black"]since the add's and deleted's cancel out the other entries[/font])
AH! Now I finally...
--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)

August 24, 2011 at 6:40 pm

#1372910
RE: Are the posted questions getting worse?

Fal (8/24/2011)
Jeff Moden (8/23/2011)
Stefan Krzywicki (8/23/2011)
Earthquake in CO yesterday and now one in VA that I felt all the way in Boston.
Hope everyone in the affected area is okay. ...
--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)

August 24, 2011 at 6:18 pm

#1372907
RE: 'Use' statement in Stored procedure...

GSquared (8/19/2011)
Jeff Moden (8/18/2011)
nellisjp (8/18/2011)
but why you'd need something like this is beyond me
I've had to do such a thing many times even if I don't necessarily agree with 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)

August 24, 2011 at 6:11 pm

#1372906
RE: Automatic XML

Matt, I absolutely agree with what you just said about setting up the "contract". You really DO need to know exactly what the data and columns are for and...
--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)

August 24, 2011 at 3:45 pm

#1372870
RE: Automatic XML

SwePeso (8/24/2011)
Also see here to remedy the encoding feature http://weblogs.sqlteam.com/peterl/archive/2009/03/05/Extract-XML-structure-automatically.aspx
And here is how you can filter out certain nodes
http://weblogs.sqlteam.com/peterl/archive/2009/06/04/Extract-XML-structure-automatically-part-2.aspx
Thanks, Peter. I'll have a look.
--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)

August 24, 2011 at 1:23 pm

#1372796
RE: Automatic XML

LutzM (8/24/2011)
Maybe one of Jacob Sebastians Blogs can help.
However, I have no idea what the performance counters will display...
But I have not seen any equivalent XQuery solution yet.
I'd already worked...
--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)

August 24, 2011 at 1:18 pm

#1372794
RE: Automatic XML

Ah... lucky me! The requirements for my task have eased up a bit. It turns out that the "data vendors" CAN provide XSD files so I'm definitely "out...
--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)

August 24, 2011 at 12:56 pm

#1372788

Viewing 15 posts - 32,746 through 32,760 (of 59,099 total)