Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,411 through 40,425 (of 59,098 total)

RE: Normalize data using Pivot WITHOUT using Aggregate function

Man, in the presence of a clustered index on the ID, that's some mighty fast code there, Chris.
--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)

December 30, 2009 at 10:05 pm

#1097748
RE: Normalize data using Pivot WITHOUT using Aggregate function

Jeff Moden (12/30/2009)
Jeff Moden (12/30/2009)
lobbymuncher (12/30/2009)
Another overcomplicated effort from the peanut gallery.
I like it. Nicely done.
Ack... I may have to take that back. The code has a triangular...
--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)

December 30, 2009 at 9:28 pm

#1097740
RE: Normalize data using Pivot WITHOUT using Aggregate function

Justin,
Please post the table creation statement and be sure to include any indexes you may have on the table.
--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)

December 30, 2009 at 8:39 pm

#1097736
RE: Normalize data using Pivot WITHOUT using Aggregate function

Jeff Moden (12/30/2009)
lobbymuncher (12/30/2009)
Another overcomplicated effort from the peanut gallery.
I like it. Nicely done.
Ack... I may have to take that back. The code has a triangular join 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)

December 30, 2009 at 8:25 pm

#1097735
RE: Normalize data using Pivot WITHOUT using Aggregate function

lobbymuncher (12/30/2009)
Another overcomplicated effort from the peanut gallery.
I like it. Nicely done.
--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)

December 30, 2009 at 8:15 pm

#1097734
RE: Normalize data using Pivot WITHOUT using Aggregate function

mister.magoo (12/30/2009)
For the sake of it, a solution which copes with new "ColumnName" values by using dynamic sql (go ahead - pork chop me or whatever you do :-D)
Heh... nah......
--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)

December 30, 2009 at 8:03 pm

#1097732
RE: Translating SQL 2005 script to SQL 2000

I'd fire the guy that hired two people... the one who didn't write/correctly promulgate the company wide rules and the guy that interviewed/hired him. 😛
I do agree, though... classic Hungarian...
--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)

December 30, 2009 at 1:39 pm

#1097659
RE: Update column

Dave Ballantyne (12/30/2009)
Jeff Moden (12/30/2009)
Here we have someone who has no clue as to how to use one the basic 4 elements of the SQL language and they're going 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)

December 30, 2009 at 1:26 pm

#1097655
RE: Update column

igngua (12/30/2009)
Hello...
I need to add a varchar type of data into a column without erase any registry of the column.
I need to add it at the end of every...
--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)

December 30, 2009 at 1:24 pm

#1097654
RE: permission to write to output file by non-sa job owner

Hollyz (12/30/2009)
that account is a domain account
And, you're absolutely sure that "domain" account can "see" the path you want to write 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)

December 30, 2009 at 1:08 pm

#1097647
RE: Update column

Here we have someone who has no clue as to how to use one the basic 4 elements of the SQL language and they're going to update a whole table....
--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)

December 30, 2009 at 1:03 pm

#1097643
RE: Performance with Bulk update

brainy (12/30/2009)
Thanks jeff..
I will consider your suggestions.. I will try that. I am also thinking on setting fill factor.. as I am updating table several times which leads 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)

December 30, 2009 at 12:52 pm

#1097639
RE: Problem using EXEC within SELECT CASE statement

AndrewSQLDBA (12/30/2009)
I have never had any issues with SSIS. Maybe it is time for a new server.
Andrew SQLDBA
Heh... unlike most, I've never had an issue with SSIS because the other...
--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)

December 30, 2009 at 12:42 pm

#1097633
RE: Can TSQL 2005 do this : ToBase64string

I just looked up and read some of the articles and scripts for this Base64 "encryption". My suggestion would be... don't bother. It's an easy hack from what...
--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)

December 30, 2009 at 12:33 pm

#1097622
RE: convert to regular time

Pratap Prabhu (12/29/2009)
drop the convert(datetime from the code and run. See what filter condition needs to be added to the case/where,(it has to be one or more records in your...
--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)

December 30, 2009 at 12:10 pm

#1097610

Viewing 15 posts - 40,411 through 40,425 (of 59,098 total)