Viewing 15 posts - 54,721 through 54,735 (of 59,067 total)
It's a JOKE
No it wasn't... I hate Oracle 😀
October 5, 2007 at 10:40 am
Select your data into a temp table that has an Identity column, and you're done.
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...
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]
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
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...
October 4, 2007 at 5:37 pm
Thanks for the heads up, Tomm... I'll check it out...
October 4, 2007 at 5:21 pm
Are you reporting on all 3 years at the same time?
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 😀
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. ...
October 4, 2007 at 9:00 am
noeld (10/3/2007)
We know that, so far, we have been able to force...
October 3, 2007 at 11:23 pm
Nothing undocumented... you need to look in BOL for the UPDATE... I've bolded the part of the update I used....
UPDATE
{
...
October 3, 2007 at 11:10 pm
Tomm Carr (10/3/2007)
October 3, 2007 at 11:06 pm
Peter,
Although the double correlated subquery will work, I'm also pretty sure it will kill batch performance because of the triangular join in it...
http://www.sqlservercentral.com/Forums/Topic359124-338-1.aspx#bm360151
October 3, 2007 at 7:31 am
Vishal,
Just a thought... Is this a permanent nonreporting you're modifiying? The reason I ask is if you're actually doing this to some "real" data (other than a reporting table),...
October 3, 2007 at 7:22 am
Viewing 15 posts - 54,721 through 54,735 (of 59,067 total)