Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,321 through 40,335 (of 59,072 total)

RE: IsNumeric not working

Heh... in this case, two NOTs make a right... or maybe a pair of properly ties walking shoes. 😀
--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)

January 7, 2010 at 6:37 pm

#1100648
RE: Tally Table

CirquedeSQLeil (1/7/2010)
Jeff Moden (1/6/2010)
The Tally table is not a panacea and isn't good for this. Dynamic SQL would be good for this. So would an (ugh!) cursor.
Are 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)

January 7, 2010 at 6:35 pm

#1100647
RE: IsNumeric not working

Jeffrey Williams-493691 (1/7/2010)
Sorry, but that won't work either - you need the following:
SELECT 1 WHERE '111' NOT LIKE '%[0-9]%'
Not quite true if you're looking for values containing only digits....
--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)

January 7, 2010 at 3:32 pm

#1100563
RE: One big "ragged right" text file!

imani_technology (1/7/2010)
Here's the problem: we are doing a proof of concept comparing SSIS and Informatica. In order for there to be a "fair fight," I can't do 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)

January 7, 2010 at 3:29 pm

#1100561
RE: sp needed

rpatil22 (1/7/2010)
Guys I will receive a string
'name',a1,b1,c1,a2,b2,c2,a3,b3,c3,a4,b4,c4
i want to make data in table
name a1 b1 c1
name a2 b2 c2
name...
--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)

January 7, 2010 at 3:21 pm

#1100552
RE: One big "ragged right" text file!

If it's a fixed field (no delimiters, each column a given width), then I just import into a single column flat table and do a simple substring split. 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)

January 7, 2010 at 3:19 pm

#1100548
RE: Hitting nVarchar(max) limitation when running exec sp_executesql

mtassin (1/7/2010)
jcdyntek (1/7/2010)
I will also check on the limits of character strings, however, if this is an internal string do you really need an nvarchar? if you used 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)

January 7, 2010 at 11:41 am

#1100404
RE: Create one record for each in quotient

Heh... might not be necessary here. You did great with the "on the fly" short list Tally. I was just telling you why I wrote the article. 🙂
--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)

January 7, 2010 at 8:59 am

#1100278
RE: CASE, WHEN, THEN!

Ah.... must look eye myself... I missed the two different datatypes. Sorry. NULL means "Unknown" and would work here.
--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)

January 7, 2010 at 8:48 am

#1100271
RE: TSQL SELECT and TABLOCK

Heh... and I missed your previous comment on that very thing. Guess it's time to get some shut-eye.
--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)

January 7, 2010 at 12:17 am

#1100039
RE: Women in Technology

Phil Factor (1/5/2010)
Some estimates describe an alarming percentage fall from 40% to 20%. Clearly something must be done to reverse the trend.
[font="Arial Black"]WHY?[/font] Hasn't anyone considered that maybe 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)

January 6, 2010 at 11:51 pm

#1100036
RE: Create one record for each in quotient

I figured that's what it was. That's why I wrote the article on the Tally table... I got tired of explaining it and can just point them to 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)

January 6, 2010 at 11:40 pm

#1100033
RE: Cursor Not Working As Expected

donne4real (1/6/2010)
I think I should have added more information. I have 2 tables. It loops through the table to see if a filename exists in both. And if it does,...
--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)

January 6, 2010 at 11:38 pm

#1100032
RE: Cursor Not Working As Expected

As a side bar for everyone else... a cursor isn't such a bad thing for such a control, here. You could concatenate all of the commands together in one...
--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)

January 6, 2010 at 11:35 pm

#1100031
RE: Performance issue on a udf - Better way to rewrite?

Lynn Pettis (1/6/2010)
To continue, I did write a blog about it Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions
Nice... I'm curious... why blog these instead of submitting them as articles?...
--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)

January 6, 2010 at 11:32 pm

#1100030

Viewing 15 posts - 40,321 through 40,335 (of 59,072 total)