Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,081 through 37,095 (of 59,072 total)

RE: XP_cmdshell DIR

Ness (8/26/2010)
SSIS?
To the best of my knowledge, SSIS doesn't have anything to get file sizes. You'd need to write a script of do a bit of an add 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)

August 26, 2010 at 11:31 pm

#1212733
RE: XP_cmdshell DIR

chrs-513176 (8/26/2010)
This gives me what I need. Thanks for the help Jeff!
You bet... thanks 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 26, 2010 at 11:28 pm

#1212732
RE: Dates from Calendar control

Riskworks (8/26/2010)
Thanks Jeff. You solution is more elegent
Yep, you are right. I meant to subtract a mi or even ss which would work as well to get right...
--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 26, 2010 at 11:24 pm

#1212727
RE: Missing sequence number

WayneS (8/26/2010)
Jeff Moden (8/26/2010)
drew.allen (8/25/2010)
This is not a complete solution. It SEEMS to work here, because all of the gaps in your sample data are one ID. If...
--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 26, 2010 at 11:17 pm

#1212724
RE: Missing sequence number

WayneS (8/26/2010)
Jeff Moden (8/26/2010)
jvanderberg (8/26/2010)
Didn't you ask if it could be done in one SELECT statement?
Who? The OP? I don't see that anywhere in the original or subsequent...
--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 26, 2010 at 11:09 pm

#1212719
RE: Convert CSV values in three columns to rows

The initial testing I just got done doing looks pretty darned good on a parameter of 100,000 elements, Oleg. I'm still playing with 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)

August 26, 2010 at 5:27 pm

#1212640
RE: Missing sequence number

jvanderberg (8/26/2010)
Didn't you ask if it could be done in one SELECT statement?
Who? The OP? I don't see that anywhere in the original or subsequent posts by 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 26, 2010 at 4:54 pm

#1212624
RE: Missing sequence number

Ram:) (8/25/2010)
Thanks for all replies..
I have used following function and select statement . Please clarify me if i am wrong.
Ok, it's wrong because it uses a WHILE loop.
It's also...
--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 26, 2010 at 4:44 pm

#1212621
RE: Missing sequence number

drew.allen (8/25/2010)
This is not a complete solution. It SEEMS to work here, because all of the gaps in your sample data are one ID. If you had gaps...
--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 26, 2010 at 4:41 pm

#1212619
RE: How to Pivot using T-SQL

sqlbi (8/26/2010)
i tired in so many ways and im getting error...
Cool... let's see what you've tried. Also, take a peek at the first link in my signature line 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)

August 26, 2010 at 4:34 pm

#1212614
RE: Encrypting text file to UTF8 using powershell

I have to ask... Am I the only one concerned that someone responsible for the successful encryption of data that needs to be encrypted doesn't know that UTF-8 isn't a...
--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 26, 2010 at 4:23 pm

#1212608
RE: Aging Calculation for Items, Based on Status

homebrew01 (8/26/2010)
I'm stuck, but I know this can't be too hard.
I have warehouse transactions that are used to calculate how long an item has been in the warehouse (aging),...
--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 26, 2010 at 4:02 pm

#1212598
RE: Are the posted questions getting worse?

BrainDonor (8/26/2010)
Paul White NZ (8/25/2010)
Made me think of the new Air New Zealand safety video:
http://www.youtube.com/watch?v=9f1awn9vBZE
My wife is suddenly more interested in our flight out there in February and wants 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 26, 2010 at 7:07 am

#1212268
RE: Normalize a table query

bonggoy cruz (8/24/2010)
I did use unpivot. I was actually aware and have used PIVOT before. I felt kind of stupid when UNPivot was suggested :D. Sometimes 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 25, 2010 at 10:46 pm

#1212057
RE: Plzz help me in replacing the cursor with Normal Sql Statements

LutzM (8/25/2010)
@mike-2: The quirky update method should not be used on joined tables. See Jeff's revised article[/url] for details.
Other than that: as just confirmed the target system is SS2K5. No...
--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 25, 2010 at 10:42 pm

#1212055

Viewing 15 posts - 37,081 through 37,095 (of 59,072 total)