Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,721 through 54,735 (of 59,072 total)

RE: Averages and Medians without a cube

I did a nasty fast median for someone else (see the following URL)... perhaps you could modify it to suit your needs.
http://www.sqlservercentral.com/Forums/FindPost352218.aspx
--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 5, 2007 at 11:40 pm

#739775
RE: Variable in flat file destination

edony44,
Does it have to be in 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)

October 5, 2007 at 11:11 pm

#739774
RE: Variable in flat file destination

mengus (10/4/2007)
edony44,
Please provide table structure and some sample data. There is a number of ways in SSIS for SQL Server 2005 to accomplish what you need.
Regards,
Wameng Vang
:blink: I'm thinking that...
--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 5, 2007 at 11:09 pm

#739773
RE: Why SQL Server is Better Than Oracle

David Russell (10/4/2007)
I know I'm not the brightest spark in the universe but what is the point of reproducing audibly, via the Audio (MP3) click, what is written 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 5, 2007 at 11:02 am

#739636
RE: Why SQL Server is Better Than Oracle

Vladimiro Buda (10/5/2007)
Well, by tha way, how is SQLServer better than Oracle?
You say that SQLServer has now some feature that Oracle 8i had in the 2000.
Partitioning, Performance,...where SQLServer is better?
I...
--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 5, 2007 at 10:55 am

#739634
RE: Why SQL Server is Better Than Oracle

It's a JOKE
No it wasn't... I hate Oracle 😀
--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 5, 2007 at 10:40 am

#739631
RE: Cartesian product of 2 tables + update a column

Select your data into a temp table that has an Identity column, and you're 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)

October 5, 2007 at 1:19 am

#739413
RE: Why SQL Server is Better Than Oracle

I've been required to use Oracle more and more in the last couple of months... the more I learn about it and the more I use it, the more I...
--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 5, 2007 at 1:16 am

#739412
RE: Query for display Rows value in column wise

It's not nice to cross post 😉
[highlight]http://www.sqlservercentral.com/Forums/Topic407185-338-1.aspx[/highlight]
--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 5, 2007 at 1:07 am

#739409
RE: Last day of the month

Why not just... don't even need a UDF this way...
DATEADD(mm,DATEDIFF(mm,0,somedate)+1,0)-1
--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 5, 2007 at 1:04 am

#739407
RE: Remove Decimals Without Rounding

Wow... I made a mess of that one :blush: It's only fast if it works right, huh 😀
Folks, don't use method 3... Tomm's right... I've got a nasty bug...
--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 4, 2007 at 5:37 pm

#739382
RE: Remove Decimals Without Rounding

Thanks for the heads up, Tomm... I'll check it out...
--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 4, 2007 at 5:21 pm

#739381
RE: Performance required on > 4 million records

Are you reporting on all 3 years at the same time?
--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 4, 2007 at 5:19 pm

#739380
RE: Limit Resources to UGLY query

Heh... and if they change the way Order By works, we'd all be screwed, too!...
...Wait, they did that 😀
--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 4, 2007 at 5:18 pm

#739379
RE: Performance required on > 4 million records

dhay1999 (10/4/2007)
Jeff,
If you are still around I'd like to see a skeleton of what you accomplished. I'm trying to do the same thing with over 150 million rows. ...
--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 4, 2007 at 9:00 am

#739141

Viewing 15 posts - 54,721 through 54,735 (of 59,072 total)