Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,731 through 47,745 (of 59,099 total)

RE: how to eliminate double quotes for column headers in flatfiledestination

I guess I don't understand... what's wrong with having the double quotes in the column headers? That's how a true CSV file should be formed.
--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)

October 15, 2008 at 6:02 pm

#885587
RE: CPU 100% and critical

we had a similar problem just last week. Couldn't explain it and still can't. All I know is that we stopped SQL Server Agent and restarted 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)

October 15, 2008 at 5:59 pm

#885586
RE: Import CSV data into a table in SQL Server 2005 CE

GAURAVKAUSHIK26 (10/14/2008)
Thanks for response. Can you please provide me any code or syntax that imports csv/txt file into SQL CE without SSIS/DTS.
Sure... if the file has no company private 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)

October 15, 2008 at 11:44 am

#885386
RE: Functio to get Amount in words.

Yep... I agree, Kevin... especially if you have a function like "ToWords". That and RegEx Replace seem to be pretty good.
--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)

October 15, 2008 at 8:14 am

#885237
RE: Too Good at Data Analysis

Derek Dongray (10/15/2008)
Matt Miller (10/14/2008)
IBM's revenue is off by a penny, which triggers an alert on someone's system, which tells EVERYONE, and next thing you know, IBM is in 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)

October 15, 2008 at 6:27 am

#885151
RE: Problem with this script, need help!

Heh... I gotta get it through my head, someday... order of predicates is not guaranteed to be in same order listed. I keep treating the bloody things like 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)

October 15, 2008 at 6:23 am

#885150
RE: How to.....

http://www.simplyhired.com/
... is one of the best sites I've run across with feeds from Monster, Dice, etc, etc.
--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)

October 14, 2008 at 11:04 pm

#885018
RE: Rebilding Indexes on a table with 100Million + rows

Maybe partition the table so you can manage smaller tables instead of one huge one.
--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)

October 14, 2008 at 10:55 pm

#885017
RE: Cannot insert duplicate key row in object 'sysmergeschemachange' with unique index 'schemachangeversion'.

So, try to manuall login to the subscriber machine using PVALDEVINO and see what happens.
--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)

October 14, 2008 at 10:48 pm

#885014
RE: Date issue

Best (10/14/2008)
i have a column called DOB(datatype :datetime) in my table A which as values like as follows
DOB
1925-12-19 00:00:00.000
1935-04-10 00:00:00.000
1929-08-19 00:00:00.000
I WANT IT TO UPDATE...
--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)

October 14, 2008 at 10:44 pm

#885012
RE: Problem with this script, need help!

leo.medina (10/14/2008)
You're right we're also asking ourselves why the select does not give us any error and here we see actual results with ten records. It's just weird!!!
Anyways, 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)

October 14, 2008 at 9:55 pm

#885008
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Heh, no rest for the weary, eh? 🙂
--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)

October 14, 2008 at 9:53 pm

#885007
RE: Problem with this script, need help!

Guess I don't see it since you have the same thing in the SELECT list... should fail there, too. Maybe, I've just not had enough coffee today. Sorry,...
--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)

October 14, 2008 at 9:26 pm

#884999
RE: Problem with this script, need help!

Heh.. yeah... you're right. Still looking.
--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)

October 14, 2008 at 9:14 pm

#884997
RE: Too Good at Data Analysis

They knew the models weren't perfect...
... but the morons did it anyway. That bloody well sums it up and that's why "Business Intelligence" is an oxymoron. 😉 There's...
--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)

October 14, 2008 at 8:51 pm

#884987

Viewing 15 posts - 47,731 through 47,745 (of 59,099 total)