Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,786 through 25,800 (of 59,099 total)

RE: Convert DD MMM YYYY to yyyymmdd in string

dc.pc100 (9/30/2013)
20130616.xlsx
201307.xlsx
HSE.201306.xlsx
HSE.201307.xlsx
2013 ICT Calendar.xls
Inv.10017355.txt
The big question would be... what do you want for the final file names for the file names above? I could guess on some of 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)

September 30, 2013 at 6:22 pm

#1654750
RE: Need Help on Fastest Search Logic

To be crystal clear, would you ever have data like the following where a given single product appeared in the CSV of more than 1 product category? I ask...
--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)

September 30, 2013 at 6:00 pm

#1654746
RE: Calculating Memory usage

Oracle_91 (9/30/2013)
Hi sql-lover,
Thanks for the query. However, this script would show only the buffer distribution. ITs doesn't include the memory allocations done outside buffer pool(i.e. memToleave or non-buffer or memory...
--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)

September 30, 2013 at 4:56 pm

#1654735
RE: Calculating Memory usage

NM... I made a mistake in looking at that code.
--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)

September 30, 2013 at 1:11 pm

#1654692
RE: Need Help on Fastest Search Logic

born2achieve (9/30/2013)
Oh that's my bad and sorry Gila.
Thank you Jeff for the information. also answer for your question on Table2 we will have duplicate product name as it contains...
--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)

September 30, 2013 at 11:42 am

#1654667
RE: Competence trumps a good cultural fit

Phil Factor (9/30/2013)
I once wrote
'the best development teams I’ve worked on embraced the whole gamut of humanity – a wild mix of cultures, sexuality, motivation, age and beliefs, spiced...
--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)

September 30, 2013 at 5:27 am

#1654495
RE: Convert DD MMM YYYY to yyyymmdd in string

dc.pc100 (9/30/2013)
How or where would i add the below
Where [SourceData] like '%[0-9]%' + 'Jan' + '[0-9]%'
as lots of data gets messed up with dwains code, and want to limit 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)

September 30, 2013 at 5:02 am

#1654487
RE: Convert DD MMM YYYY to yyyymmdd in string

dc.pc100 (9/29/2013)
Awesome guys thank you so much. Beats manually going through 200,000 rows in multiple excel files to change the date 🙂
Like everrything else, "It Depends". If I was...
--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)

September 29, 2013 at 9:53 pm

#1654406
RE: Convert DD MMM YYYY to yyyymmdd in string

dc.pc100 (9/29/2013)
The following will work but only with the understanding that no other numeric digits can exist in the string as the current test data would have it.
Awesome, thanks...
--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)

September 29, 2013 at 9:19 pm

#1654404
RE: Convert DD MMM YYYY to yyyymmdd in string

dwain.c (9/29/2013)
Running the code you quoted Jeff, I get these results.
sourcedata ...
--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)

September 29, 2013 at 8:41 pm

#1654402
RE: Need Help on Fastest Search Logic

born2achieve (9/29/2013)
Thanks Jeff and Gila for the reply. I totally agree your answers. Appreciate gentle men.
No problem although Gail is one fine lady with a manly avatar. 😛
Do you have...
--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)

September 29, 2013 at 8:23 pm

#1654400
RE: Convert DD MMM YYYY to yyyymmdd in string

dwain.c (9/29/2013)
Ok. This should work.
But someone I'm sure will probably come up with a better way.
WITH SampleData (sourcedata) AS
(
SELECT '12 Jan 2013 Test.docx'
...
--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)

September 29, 2013 at 8:14 pm

#1654399
RE: Competence trumps a good cultural fit

The title of the article is "Competence trumps a good cultural fit" and it pretty much went that way in the article. I say that one without the other...
--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)

September 29, 2013 at 7:19 pm

#1654396
RE: Is this Correct Use of Dynamic SQL???

pietlinden (9/28/2013)
If you understand the repercussions of code that can't be optimized...
Actually, one of the best reasons for using Dynamic SQL is to optimize the performance of "Catch All" queries....
--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)

September 29, 2013 at 6:19 pm

#1654384
RE: Competence trumps a good cultural fit

bmcgirr (9/29/2013)
Nice to be challenged with an opinion I can't agree with 🙂
I think you've put forward a bit of a straw man argument here. As a minimum, an interviewee...
--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)

September 29, 2013 at 5:16 pm

#1654377

Viewing 15 posts - 25,786 through 25,800 (of 59,099 total)