Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,336 through 40,350 (of 59,098 total)

RE: mod 10 weights 1, 2

I don't know which will be faster nor which you prefer to read nor am I sure which is correct (I don't subtract my result from 10 like Lynn did......
--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 9:04 pm

#1100677
RE: mod 10 weights 1, 2

Lynn Pettis (1/7/2010)
Assuming you have a Tally table, how about the following code:
declare @ TestData varchar(12);
set @TestData = '03EA12J77';
select
(10 - (sum(
...
--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:45 pm

#1100673
RE: Best Practices for deploying a single database across multiple sites

The "better mousetrap" requires a "better pipe".
--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:11 pm

#1100666
RE: Time For A View?

jmiaebrown (1/7/2010)
Hello. I have a PROJECT_TBL that has id references to other tables. IE. resource_id for the RESOURCE_TBL, task_id for the TASK_TBL. I want to create...
--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:08 pm

#1100664
RE: Jr sql dba phone interview questions

ddlawal (1/7/2010)
Hi all,
I am a rookie sql jr dba preparing for a phone interview. Would appreciate any input on what kind of questions to expect.
I am as rookie as 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)

January 7, 2010 at 7:58 pm

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

Only if it's a constant... in 2k5, it'll take any variable datatype that's implicitly convertable to NText and that includes VARCHAR.
--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 7:36 pm

#1100661
RE: Four Rules for NULLs

Greg Martin-419640 (1/7/2010)
Hello and happy new year everyone.
I've looked in the thread and not managed to see an answer to this. I use SQL server.
If I have a Customers table,...
--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 7:20 pm

#1100659
RE: Four Rules for NULLs

bear in a box (6/24/2009)
...but this assumes one knows very field in the table has been allowed or not allowed nulls. this is not the case which is why 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 7:11 pm

#1100657
RE: Women in Technology

Steve Jones - Editor (1/7/2010)
We'll never eliminate bias.
Heh... I found a way... I wake up hating everyone and make exceptions from there. Pork chops for everyone! 😛
--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:58 pm

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

imani_technology (1/7/2010)
Okay, but what if we weren't using a SQL Server database? What if we were using SSIS to import a text file into Vertica, for example? Or...
--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:51 pm

#1100652
RE: Create a new column with criteria

All that's good but I don't understand what you understand. Please read and heed the article located at the first link in my signature line below so we 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)

January 7, 2010 at 6:45 pm

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

Viewing 15 posts - 40,336 through 40,350 (of 59,098 total)