Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,216 through 49,230 (of 59,102 total)

RE: Truncating text files to a certain number of lines

You mean withing T-SQL? Sure... import the file... delete the desired rows... export the file. You could also write some VBS using the System File Object to do...
--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)

July 14, 2008 at 7:57 am

#842386
RE: Transpose data

First, it would be a great help if you'd take a little time to post your data in a more readibly usable format so that we can actually write 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)

July 14, 2008 at 6:51 am

#842340
RE: how to Convert varchar to Numeric

... heh... and before anyone even thinks of suggesting ISNUMERIC, try this...
SELECT ISNUMERIC('$1000') UNION ALL
SELECT ISNUMERIC('1,000') UNION ALL
SELECT ISNUMERIC('3d2') UNION ALL
SELECT ISNUMERIC('2e3')
--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)

July 14, 2008 at 6:46 am

#842336
RE: how to Convert varchar to Numeric

Obviously, that WHERE clause won't catch everything... but this will...
WHERE tblItem.strItem NOT LIKE '%[^0-9]%'
The circumflex (^) also means "NOT".
--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)

July 14, 2008 at 6:44 am

#842333
RE: how to overcome sql injection

In other words, you will need to rewrite part of the app to use stored procedures instead of dynamic embedded SQL.
--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)

July 14, 2008 at 6:39 am

#842331
RE: bulk insert

bodhilove (7/13/2008)
I have a table that has 1 field - email char(30). I am trying to bulk insert from a csv file. Some of the emails are bigger than 30...
--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)

July 14, 2008 at 6:32 am

#842329
RE: Truncating text files to a certain number of lines

Instead of writing to a text file, why not write to a table where each row has a "create date"?
--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)

July 14, 2008 at 6:30 am

#842326
RE: Cumulative Addition

That's called a "Running Total". See the following URL for one of the better ways to do that.
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
--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)

July 14, 2008 at 6:27 am

#842323
RE: Launching Excel VBA from SSIS?

I'm no DTS or SSIS "Ninja", so I can't help there. What I have done is create another spreadsheet that would open the others and export their data 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)

July 14, 2008 at 6:18 am

#842317
RE: Launching Excel VBA from SSIS?

Eric,
What is it that you intend to do with the VBA?
--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)

July 14, 2008 at 5:13 am

#842297
RE: Performance Issue with when Proc called thru SSIS "SQL Task"

Heh... if you're happy with 4 hours, I'm happy. 🙂
--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)

July 14, 2008 at 12:00 am

#842196
RE: Two jobs run same time one has to wait.

You're looking at the code that SQL Server generated to run some user code... better if you look at the user code. Look for long transactions to begin with...
--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)

July 13, 2008 at 11:55 am

#842119
RE: Performance Issue with when Proc called thru SSIS "SQL Task"

Just a side bar... if the job is taking 4 hours on anything to run, you might want to look at tuning the code instead of trying to tune SSIS....
--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)

July 13, 2008 at 11:51 am

#842117
RE: What's an MVP?

Heh... cgnospam words are pretty strong and most folks who have an MVP would certainly be upset about being called a "marketing whore" or maybe even an "evangelist" :hehe:, but...
--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)

July 13, 2008 at 11:46 am

#842115
RE: Split data

You already said that... this is the third time... relax... someone else will answer...
--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)

July 13, 2008 at 10:54 am

#842106

Viewing 15 posts - 49,216 through 49,230 (of 59,102 total)