Viewing 15 posts - 3,031 through 3,045 (of 8,416 total)
For interest's sake, here's a 2008 solution based on hierarchyid (which is a very useful type for tree problems):
DECLARE @TABLE
TABLE (
...
July 13, 2010 at 4:42 am
Jeff Moden (7/6/2010)
Oddly enough, I'd heard that Forward_Only Read_Only was faster than Fast_Forward. Heh.... guess what I'm NOT going to test. :hehe:
Yep, but you also need to specify STATIC...
July 6, 2010 at 6:44 am
Jeff Moden (7/6/2010)
...the only reason why I know how to write one (or at least I think I know how to write one :hehe:)...
The cursor you wrote is a FAST_FORWARD...
July 6, 2010 at 6:16 am
Andrew-443839 (7/5/2010)
As a (rather late) post script to the thread, in the end we did use synonyms, with a successful outcome. 🙂Thanks again.
Andrew
Good to hear, thanks for the update 🙂
July 6, 2010 at 5:39 am
Gianluca Sartori (7/2/2010)
July 4, 2010 at 7:07 am
Gianluca Sartori (7/2/2010)
Well, actually it's a SQLServer day...
Serves you right for still running SQL Server 2000 😛 😉
July 2, 2010 at 9:01 am
Gianluca Sartori (7/1/2010)
No, the two queries get absolutely different plans when unioned together. That's what I don't understand. How can UNION ALL change the plan so dramatically?
The simple answer...
July 2, 2010 at 8:58 am
July 2, 2010 at 7:57 am
Eugene Elutin (7/2/2010)
I guess it is more than enough to know these formulas exist...
I remember very few facts since facts do not age well.
I have mad Googling skillz though :laugh:
July 2, 2010 at 7:37 am
WayneS (7/2/2010)
Steve Jones - Editor (7/1/2010)
What did I do?I'm not renewed now. And perhaps I won't be if PASS gets to weigh in.
Well, it DOES list you in it. Guess...
July 2, 2010 at 7:34 am
Chris Morris-439714 (7/2/2010)
Paul White NZ (7/2/2010)
Precision and scaleMeasuring worm 😉
Funny :laugh:
July 2, 2010 at 7:32 am
Gianluca Sartori (7/2/2010)
Paul White NZ (7/2/2010)Reported as spam - assuming no-one here is in the market for kitchen cabinets?
On days like today I wish I was...
Seems like Gianluca's having an...
July 2, 2010 at 7:31 am
Dave Ballantyne (7/2/2010)
Thought about it but gave the benefit of the doubt.
There have been a spate of copy-n-paste replies from one-point members with a link to something random.
I suppose...
July 2, 2010 at 7:30 am
mpdillon (7/2/2010)
Again, thanks to both of you for your efforts in explaining what is going on.
No worries - that's what we do.
Oh, and in case you were wondering, very very...
July 2, 2010 at 7:10 am
Eugene Elutin (7/2/2010)
July 2, 2010 at 7:08 am
Viewing 15 posts - 3,031 through 3,045 (of 8,416 total)