Viewing 15 posts - 32,791 through 32,805 (of 59,102 total)
IIRC, a STATIC cursor builds its own Temp Table behind the scenes, anyway.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2011 at 9:30 pm
doug 40899 (8/19/2011)
I've tried that and didn't get back all of the correct results. I did a line by line comparison for running my query with everything after the union...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2011 at 7:43 pm
GilaMonster (8/19/2011)
Jeff Moden (8/19/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2011 at 7:29 pm
Lynn Pettis (8/19/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2011 at 7:17 pm
doug 40899 (8/19/2011)
HEART HOSP - MIDIDDODI 2011-08-19 07:00:00.0002011-08-19 13:00:00.000Added
HEART HOSP - MOORE 2011-08-19...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 2:21 pm
forsqlserver (8/18/2011)
I have two databases one is of HRMS application and another for forefront application.Now some table data comes from HRMS database to forefront...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 2:15 pm
David Burrows (8/19/2011)
Another great article Jeff 🙂Jeff Moden (8/8/2011)
... some would say that I, indeed, have no taste budsSurely you meant 'no taste' 😛
heh... that, too! And don't call...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 2:07 pm
abhishek_dwivedi03 (8/19/2011)
I am not able to do it even when i am trying to do it in my base machine
Assuming that you mean just changing the Initial Size as I...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 2:05 pm
Eugene Elutin (8/19/2011)
Jeff Moden (8/19/2011)
That's because someone made it difficult. See if you understand the following modifications...
Not at all...
It was because someone wanted to turn 1,2,3,4,5,6,7,8,... into 1,2,3,4,1,2,3,4,...
not 0,1,2,3,4,5,6,7,......
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 1:12 pm
Phil Parkin (8/19/2011)
..Please see the farticle at
Got a slight wind problem Jeff? 😀
Heh... I've made that recommendation so many times that it has, indeed, become a bit of a naturally...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 1:06 pm
WayneS (8/19/2011)
Jeff Moden (8/19/2011)
GSquared (8/19/2011)
Jeff Moden (8/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 1:03 pm
Kiara (8/19/2011)
Jeff Moden (8/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 1:01 pm
GilaMonster (8/19/2011)
Jeff Moden (8/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 12:58 pm
GSquared (8/19/2011)
Jeff Moden (8/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 11:58 am
GSquared (8/19/2011)
Jeff Moden (8/18/2011)
Dang... I knew there was something else I wanted to ask and forgot it for a moment. If it's not obvious that I'm no SSIS-Ninja, let...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2011 at 11:49 am
Viewing 15 posts - 32,791 through 32,805 (of 59,102 total)