Jeff Moden

Forum Replies Created

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

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
RE: Problem with this script, need help!

If FName has no spaces, the CHARINDEX will return 0 and then you subtract 1 to make the operand of LEFT a negative number. You need to check for...
--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:44 pm

#884985
RE: Removing partially duplicate records in SQL

Max,
Can there be a 4th possibility or not?
RECID COL1 COL2 ...
--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:32 pm

#884984
RE: To get rows in CSV format

Shree (10/14/2008)
Hi, I saw that article and tried but its not working. Its giving me null values.
What did you try? Please post the code and the data you tried...
--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 7:23 pm

#884981
RE: Functio to get Amount in words.

TheSQLGuru (10/14/2008)
That site has a lot of really great stuff. Aaron Bertrand, IIRC.
And I too think this is a presentation layer item. Or perhaps a CLR function??
I agree......
--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 7:21 pm

#884980

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