Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,156 through 52,170 (of 59,102 total)

RE: Simple Method for Importing Ragged files

admin (3/5/2008)
Jeff Moden (3/5/2008)
And, no... I'm not making fun of anyone who uses DTS... if you take it that way, then I apologize. I'm just saying I've always...
--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)

March 5, 2008 at 9:39 am

#785592
RE: Simple Method for Importing Ragged files

paul.ibison (3/5/2008)
Thanks Jeff. The name makes sense but I can find no reference to it. Can you provide a link to the "mixed rowtype" definition (search for "mixed rowtype" in...
--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)

March 5, 2008 at 9:35 am

#785589
RE: I got burned today at a SQL Server Interview!

Grant Fritchey (3/5/2008)
FWIW, I put two people through phone screens yesterday. Both had more than 8 years experience in SQL Server. Both were listed as senior level consultants. Neither could...
--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)

March 5, 2008 at 9:19 am

#785574
RE: Simple Method for Importing Ragged files

Paul Ibison (3/4/2008)
Comments posted to this topic are about the item
Pretty good article, Paul... straight and to the point.
--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)

March 5, 2008 at 9:10 am

#785565
RE: Simple Method for Importing Ragged files

admin (3/5/2008)
Definitely an ingenious solution; however, it can quickly become a poor approach when having to deal with larger import file -think telephone call records for instance.
I've found that 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)

March 5, 2008 at 9:10 am

#785563
RE: Simple Method for Importing Ragged files

brewmanz.sqlservercentral (3/5/2008)[hrI was hoping for the import of the classic ragged-right file - a variable number of fields in records that are wanted.
For your definition of "ragged right", is...
--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)

March 5, 2008 at 8:55 am

#785552
RE: Simple Method for Importing Ragged files

paul.ibison (3/5/2008)
True - the title is a little misleading. The problem is that there isn't a 'correct' term for such files and this is the nearest commonly understood one. Anyway,...
--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)

March 5, 2008 at 8:51 am

#785545
RE: Get Only the File Name

Sure... dunno how many of these you have to do, but the following is about twice as fast because there's only 1 Reverse and RIGHT is faster than SUBSTRING.
[font="Courier New"]DECLARE&nbsp@FileName&nbspVARCHAR(256)
&nbsp&nbsp&nbsp&nbspSET&nbsp@FileName&nbsp=&nbsp'D:\File\Data\test\Test.xls'
&nbspSELECT&nbspRIGHT(@FileName,CHARINDEX('\',REVERSE(@FileName))-[/font]1)
Of...
--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)

March 5, 2008 at 8:41 am

#785537
RE: Need to return query result in 0.02 sec

I asked the business analyst to make sure how many shopper actually has those fields populated.
Wait a minute... are you saying that a system already exists and already has customers...
--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)

March 5, 2008 at 8:19 am

#785518
RE: Help on splitting the name field in a query

Ya know... I busted a bit of a hump for ya here... and no one on the other forum came close... the least you could do, MH, is let me...
--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)

March 4, 2008 at 8:21 pm

#785285
RE: Need to return query result in 0.02 sec

Steady... don't let this shake you, Loner...
And 5000 hits per second does not equal .02 seconds... on a single cpu system, that would be .0002 seconds. Multiply that 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)

March 4, 2008 at 7:35 pm

#785280
RE: Varchar(max) problem in SQL server 2005

The length of the number of characters plus 6 or 8 bytes worth of length info.
Question is, why are you using VARCHAR(MAX) if it'll never get bigger than a thousand...
--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)

March 4, 2008 at 7:10 pm

#785276
RE: small issue

Heh... And the GUI rules... it may take longer and it may run slower, but the GUI rules.
Bill Gates was right 15 years ago... someday there won't be any...
--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)

March 4, 2008 at 6:50 pm

#785273
RE: Timetable report

spencepa (3/4/2008)
Matrix seems to work but if a student has a 15 min tutorial, this fills a whole column the same as a hour
What do you want it to do?
--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)

March 4, 2008 at 5:18 pm

#785265
RE: Selecting random rows

Based on that link, I'm thinking this is someone's homework... wait a minute... I've got a porkchop around here somewhere... maybe even a Yak Burger, huh, Peter?
--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)

March 4, 2008 at 4:54 pm

#785263

Viewing 15 posts - 52,156 through 52,170 (of 59,102 total)