Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,406 through 39,420 (of 59,098 total)

RE: Sync Production Databases with Stage

Agreed... there are many ways to do one thing. I just think that, for the reasons previously stated, transactional replication from prod to dev would be the wrong thing...
--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 10, 2010 at 11:24 pm

#1131802
RE: T-SQL help

That kind of presupposes that you know what order the delimited parameter is going to be in, doesn't 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)

March 10, 2010 at 11:21 pm

#1131799
RE: Check Duplicate

Very cool. Thank you for the feedback.
--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 10, 2010 at 11:18 pm

#1131794
RE: Are the posted questions getting worse?

Jack Corbett (3/10/2010)
Elliott W (3/10/2010)
I'm wondering if any of the "regulars" would be interested in peer-reviewing an article related to SSIS processing concurrency. I've had a lot of questions...
--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 10, 2010 at 9:49 pm

#1131773
RE: Why use N before any string

You're welcome. Thank you for the feedback.
--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 10, 2010 at 9:43 pm

#1131770
RE: procedure or direct query?which one is best

Heh... I did beat around the bush a bit, huh? 😛
--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 10, 2010 at 9:37 pm

#1131769
RE: Removing Blank Fields

Well done!
--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 10, 2010 at 9:34 pm

#1131767
RE: Scalar-valued Functions in Where clause

True enough. But if you can't or won't use a CLR solution, one of the myriad Tally table solutions will do the job very quickly as well especially 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 10, 2010 at 9:07 pm

#1131763
RE: Concatenate column rows into one row with a group by

MelissaLevitt (3/10/2010)
I convinced my boss not to concanate.
Why? It's about the only option you have in 2000. Use the function I demo'd in the article for 2000.
--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 10, 2010 at 8:02 pm

#1131754
RE: procedure or direct query?which one is best

mjarsaniya (3/9/2010)
my dotnet application generate new records based on some criteria and it is always row by row.
Ummm... you could possibly do the same thing in a stored procedure. ...
--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 10, 2010 at 6:57 pm

#1131744
RE: Scalar-valued Functions in Where clause

James A Dionne (3/10/2010)
Muddy...might as well be Oil....Of to the search engine I go. Thanks for the help on this though it was a HUGE help.
Jim
Heh... understood. So,...
--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 10, 2010 at 6:45 pm

#1131740
RE: Having total amount at every row level

akmerve (3/9/2010)
Hello,
I'd like to have total value of amount paid (PAID) iterated at every row level. For instance, by using the query shown below, I would be able to...
--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 10, 2010 at 6:11 pm

#1131737
RE: Having total amount at every row level

Thanks for the article referral, Chris. 🙂
--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 10, 2010 at 6:09 pm

#1131736
RE: Complicated Quey help

Saravanan_tvr (3/10/2010)
Hi,.
I have a table for example
table 1
columns are : Item_no , stock1,stock2 ,date
rows ...
--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 10, 2010 at 6:00 pm

#1131734
RE: select all field except field wich have NULL value

vaibhav.tiwari (3/10/2010)
Bhuvnesh (3/10/2010)
sinamora (3/9/2010)
Day1 Day2 Day3 Day4 Day5
12 3 ...
--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 10, 2010 at 5:55 pm

#1131733

Viewing 15 posts - 39,406 through 39,420 (of 59,098 total)