Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,896 through 32,910 (of 59,099 total)

RE: Getting current date as part of an Stored Procedure

doug 40899 (8/12/2011)
Actually ... in going back through my code, I realized I missed something. The time and date for this process is stored in two fields. Start time and...
--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 12, 2011 at 8:39 pm

#1368299
RE: Are the posted questions getting worse?

Grant Fritchey (8/11/2011)
Brandie Tarvin (8/11/2011)
Grant Fritchey (8/11/2011)
Well done Brandie. The only real author I know and we still haven't met.
I think it's hilarious that you think you're not a real...
--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 12, 2011 at 6:37 am

#1367872
RE: Are the posted questions getting worse?

Brandie Tarvin (8/11/2011)
I'm published again! "Tales We'll Tell Tomorrow" is the final chapter in the Shadowrun Street Legends sourcebook. It's a novelette this time and my editor loved my fight...
--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 12, 2011 at 6:31 am

#1367865
RE: Are the posted questions getting worse?

Lynn Pettis (8/11/2011)
Forever it won't dominate your destiny. Life there is after the dark side.
I was going to wait until tomorrow night, but it is close enough.
I am resigning...
--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 12, 2011 at 6:28 am

#1367861
RE: Hidden RBAR: Counting with Recursive CTE's

Kenney Hill (8/11/2011)
Plus you could always let slip something embarrassing or funny or both about Jeff in the article!:hehe:
Heh... the fact that I talk with the dust bunnies isn't bad...
--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 12, 2011 at 6:20 am

#1367854
RE: Hidden RBAR: Counting with Recursive CTE's

Bill Kline-270970 (8/11/2011)
Excellent article. A great example of why I come to SQLServerCentral.com . . . to learn from the best.
Thanks, Bill. :blush: I really appreciate 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 12, 2011 at 6:18 am

#1367852
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Apologies for my apparent absence on this thread. Looks like I have a bit more testing to do. Thanks John, Mark, and 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)

August 12, 2011 at 6:02 am

#1367843
RE: import flat file through SSIS

Chelo (8/11/2011)
Hi Jeff- I realize this is an old post, but the problem's current. :hehe:
The issue I have is similar to others. I received .txt files with the pipe 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)

August 11, 2011 at 1:36 pm

#1367544
RE: Best practices

Please try Google. Search for SQL SERVER "BEST PRACTICES".
--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 10, 2011 at 10:39 pm

#1367049
RE: Getting current date as part of an Stored Procedure

Ninja's_RGR'us (8/10/2011)
doug 40899 (8/10/2011)
Ok so I was told just a moment ago that both hour and minute would need to be included in my SP. What's the syntax for that?
SELECT
--removes...
--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 10, 2011 at 7:55 pm

#1367029
RE: Hidden RBAR: Counting with Recursive CTE's

Jon Russell (8/10/2011)
As usual, excellent! Thanks, Jeff.
You bet, Jon. Thanks for stopping by and 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)

August 10, 2011 at 6:31 pm

#1367019
RE: Hidden RBAR: Counting with Recursive CTE's

lstrashnoy (8/10/2011)
Thanks Jeff.
I actually agree. I used this code in mySQL and it works pretty efficient. Unfortunately SQL Server not optimizing the way mySQL does. And because it has 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)

August 10, 2011 at 6:30 pm

#1367018
RE: Hidden RBAR: Counting with Recursive CTE's

Paul Herbert (8/10/2011)
As usual a good article Moden.
A minor correction if you don't mind. If you are going to quote my 'Really?!", I think it needs both...
--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 10, 2011 at 6:28 pm

#1367017
RE: Any easy way to find if duplicate rows exist in a table?

Gosh... I wouldn't use CHECKSUM for such a thing. It's nothing but a simple Exclusive OR and getting duplicate CHECKSUM values for different data is much more likely than...
--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 10, 2011 at 6:14 pm

#1367016
RE: Data Matters

Hear here! This editorial should be required reading for anyone involved with data especially the managers that want the data turned into information. Well done, Steve!
--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 10, 2011 at 6:00 pm

#1367011

Viewing 15 posts - 32,896 through 32,910 (of 59,099 total)