Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,736 through 54,750 (of 59,089 total)

RE: Cartesian product of 2 tables + update a column

Man, I do wish they'd fix the "code" windows so they don't triple space... all the pretty formatting I did got slammed to the left here...
Hey Steve! When are...
--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 6, 2007 at 11:00 am

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

I forgot to mention, empty column will be filled sequentially after user submits a starting number.
The task at hand is I have to filter 100,000 records down to perhaps...
--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 6, 2007 at 10:54 am

#739793
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

Viewing 15 posts - 54,736 through 54,750 (of 59,089 total)