Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,376 through 48,390 (of 59,102 total)

RE: I AM HAVING THIS UNIQUE AND STUPID SITUATION IN SSIS FROM MAINFRAME

No extensions on the file names?
--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 11, 2008 at 9:39 pm

#870734
RE: Off IF...ELSE Behavior

Here you go, Jody...
--===== If the temp table already exists, drop it.
-- This should be commented out in a production environment
...
--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 11, 2008 at 7:54 pm

#870727
RE: Patindex

Manie, great primer on PatIndex!
There is hundreds of other ways to use these functions and the way I used here is most probably not the best way so, if anyone...
--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 11, 2008 at 7:35 pm

#870726
RE: Working part-time

One of the folks on this very forum said it best... "The extraordinary DBA is the first person someone goes to when they need help, not the last." Sounds...
--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 11, 2008 at 7:13 pm

#870722
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Thanks for the awesome feedback, Hans. You made my day. Just remember, the Tally table is not a panacea... it cannot be used for all things that loop....
--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 11, 2008 at 7:09 pm

#870720
RE: String function

On the other hand, look at the bright side... 🙂 They have such a crappy DB that they need someone like you to wade through it and fix things....
--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 11, 2008 at 7:02 pm

#870719
RE: Off IF...ELSE Behavior

Jody Claggett (9/11/2008)
...but it looks like your code sample is suming the data based on the fiscal quarter.
What I am looking for is to sum the YTD quota up...
--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 11, 2008 at 6:54 pm

#870716
RE: killing old spids

Whew! Thanks for the feedback, Fraggle. Thought I missed something:).
--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 11, 2008 at 6:50 pm

#870714
RE: I AM HAVING THIS UNIQUE AND STUPID SITUATION IN SSIS FROM MAINFRAME

Just for grins, I'd still like to know the naming convention of the files that aren't empty../. 😉
--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 11, 2008 at 6:37 pm

#870712
RE: How do I determine Free & Total Space for disk drives, using T-SQL?

Those are all good, but let's revisit the OP's restrictions...
xp_fixeddrives returns FREE disk space, but not TOTAL disk space.
xp_cmdshell will not work because this is a high security place.
sp_OACreate, sp_OAMethod,...
--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 11, 2008 at 6:34 pm

#870711
RE: Freak query ...

virgilrucsandescu (9/10/2008)
I have these queries:
1a - select * from import_cc_requests where reference not in (select reference from import_cc_payments )
or
1b - select * from import_cc_requests where rtrim(reference) not in (select rtrim(reference)...
--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 10, 2008 at 10:38 pm

#870107
RE: Off IF...ELSE Behavior

Heh... you want to do 12 "IF's" per query, Jody? No, no need for IF's here. You didn't post any test data so the outer query...
--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 10, 2008 at 9:28 pm

#870098
RE: Off IF...ELSE Behavior

Crud, I made a mistake on the fiscal year :blush:... don't use the code above... I'll post a correction soon.
--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 10, 2008 at 9:24 pm

#870095
RE: Off IF...ELSE Behavior

Sorry... deleted this post... I made an error in the code. Repaired further on below...
--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 10, 2008 at 9:14 pm

#870093
RE: Freak query ...

Lowell (9/10/2008)
two also i prefer to use a left join syntax instead..
Check the execution plans of both on a set of big tables sometime...
--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 10, 2008 at 8:22 pm

#870086

Viewing 15 posts - 48,376 through 48,390 (of 59,102 total)