Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,511 through 42,525 (of 59,067 total)

RE: UPSERT USING SSIS 2005

Yep! Fourth here! Add a bit of a write up to go with all the great pictures and submit that bad boy as an article. I'm sure...
--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 5, 2009 at 4:11 pm

#1035120
RE: Date Range within a Date Range

aktikt (8/5/2009)
Hi all,
Jeff, thanks for your patronizing complements... Just kidding. I sincerely thank you. I received some helpful replies particularly Nigel's.
Nigel, this is an excellent...
--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 5, 2009 at 10:02 am

#1034925
RE: Are the posted questions getting worse?

Jack Corbett (8/5/2009)
Hey Steve, check out this guys posts (http://www.sqlservercentral.com/Forums/Search1-0-2.aspx?SessionID=euwat2555c1qqdnch3bhfpq1&SortBy=2&SortOrder=1) both have turorials as Word docs attached. I didn't read the docs, but did suggest they submit them...
--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 5, 2009 at 9:45 am

#1034910
RE: Looking for advice on calendar scheduling

dsteinschneider ,
Keep it simple... just a simple CREATE TABLE script and a couple dozen rows of readily consumable data so folks can work on the problem of distribution of 5...
--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 5, 2009 at 9:39 am

#1034902
RE: Using CURSOR

Gianluca Sartori (8/5/2009)
Hi Jeff, thanks for chiming in!
When will the article be online again? It's hard to explain this technique to others without the help of your article... expecially for...
--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 5, 2009 at 9:35 am

#1034897
RE: Primary Key- char 12

Heh... that's why I plan on "growth" and I'll always make VARCHAR variables about 50% bigger than they need to be.
I do wish that MS would come out with type...
--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 5, 2009 at 9:31 am

#1034890
RE: How did good DBAs become good DBAs

SQL Iron Chef (8/4/2009)
Does Oracle have a bigger market than SQL Server? If so they'll be more job opportunities right? I don't know if I'm correct but base of what...
--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 5, 2009 at 9:22 am

#1034879
RE: Building an API

Paul (8/5/2009)
... and there are a few situations where software is just too complex that it's hard to navigate the help and find everything you want to do. Or 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)

August 5, 2009 at 9:10 am

#1034869
RE: Date Range within a Date Range

nigel (8/5/2009)
aktikt,
Apologies, just noticed that you don't want it grouped by ClaimID, just the Month and Year.
Try this slightly modified version instead:
SELECT
...
--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 5, 2009 at 9:03 am

#1034865
RE: Import Performance

PeterG (8/5/2009)
wanted to post in case anyone was interested in outcome.
I went through the set up with the import/export wizard and saved it to a file and added the package...
--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 5, 2009 at 8:49 am

#1034850
RE: help with pulling values for multiple dates...

quayludious (8/4/2009)
Is there a better way than using the inner joins?
If I'm reading your code example correctly, the answer is "yes, absolutely". Please post the code for the function...
--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 4, 2009 at 9:54 pm

#1034614
RE: Using CURSOR

Just don't get the idea that you can use any ol' index to do this... It MUST be a clustered index.
--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 4, 2009 at 9:46 pm

#1034611
RE: Using CURSOR

willian (8/4/2009)
Hi, thanks for helping!
This code will process each row using @RESULT from one line to another?
I need take the @RESULT from atual row and use it on the next...
--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 4, 2009 at 9:41 pm

#1034609
RE: Building an API

Heh... still on a roll, Steve. Keep it going. I am, however, glad you changed your shirt from the last time.
I can't get over how many people are...
--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 4, 2009 at 9:35 pm

#1034606
RE: Primary Key- char 12

pzmrcd (8/4/2009)
Hi
We have an existing application that uses a table with a Primary ket tat has been set to char[12].
This was developed many years back and due 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)

August 4, 2009 at 9:26 pm

#1034603

Viewing 15 posts - 42,511 through 42,525 (of 59,067 total)