Viewing 15 posts - 54,721 through 54,735 (of 59,072 total)
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
Change is inevitable... Change for the better is not.
October 5, 2007 at 11:40 pm
edony44,
Does it have to be in SSIS?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 5, 2007 at 11:11 pm
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
Change is inevitable... Change for the better is not.
October 5, 2007 at 11:09 pm
David Russell (10/4/2007)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 5, 2007 at 11:02 am
Vladimiro Buda (10/5/2007)
You say that SQLServer has now some feature that Oracle 8i had in the 2000.
Partitioning, Performance,...where SQLServer is better?
I...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 5, 2007 at 10:55 am
It's a JOKE
No it wasn't... I hate Oracle 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
October 5, 2007 at 10:40 am
Select your data into a temp table that has an Identity column, and you're done.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 5, 2007 at 1:19 am
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
Change is inevitable... Change for the better is not.
October 5, 2007 at 1:16 am
It's not nice to cross post 😉
[highlight]http://www.sqlservercentral.com/Forums/Topic407185-338-1.aspx[/highlight]
--Jeff Moden
Change is inevitable... Change for the better is not.
October 5, 2007 at 1:07 am
Why not just... don't even need a UDF this way...
DATEADD(mm,DATEDIFF(mm,0,somedate)+1,0)-1
--Jeff Moden
Change is inevitable... Change for the better is not.
October 5, 2007 at 1:04 am
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
Change is inevitable... Change for the better is not.
October 4, 2007 at 5:37 pm
Thanks for the heads up, Tomm... I'll check it out...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 4, 2007 at 5:21 pm
Are you reporting on all 3 years at the same time?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 4, 2007 at 5:19 pm
Heh... and if they change the way Order By works, we'd all be screwed, too!...
...Wait, they did that 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
October 4, 2007 at 5:18 pm
dhay1999 (10/4/2007)
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
Change is inevitable... Change for the better is not.
October 4, 2007 at 9:00 am
Viewing 15 posts - 54,721 through 54,735 (of 59,072 total)