Viewing 15 posts - 30,391 through 30,405 (of 59,102 total)
Heh... crud. Two decent links to how to learn it. That probably means that I'm going to have to spend some time learning about it. π
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2012 at 4:02 pm
opc.three (4/9/2012)
L' Eomot InversΓ© (4/9/2012)
Jeff Moden (4/8/2012)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2012 at 3:59 pm
I'll search for the error message when I get home but this is going to be a tough one to troubleshoot from here. I'm not sure there's anything I'll...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2012 at 3:57 pm
pamozer (4/10/2012)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2012 at 3:55 pm
sbj1411 (4/10/2012)
Resolved the issue in TSQL using the CTE.Thanks everyone for your suggestion and help π
Would you post your code, please? It might help someone else. Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2012 at 3:52 pm
balbirsinghsodhi (4/10/2012)
A call to 'CreateProcessAsUser' failed with error code: '1314'.
I am sure that this error related...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 10, 2012 at 9:17 am
dwain.c (4/9/2012)
One more question though. Who is Bob and why is he my uncle? π
It's "British". It means the same as when we Americans say "and you're done"!
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2012 at 11:47 pm
Actually, if it were my code, I'd probably use the recursive CTE just to number the rows in the correct order using a Hierarchical Path concatenation and dump it into...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2012 at 11:44 pm
dwain.c (4/9/2012)
That neat little trick with HRoot that you did in the CTE is just what I needed to get rid of the silly OR that I did on my...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2012 at 11:34 pm
CELKO (4/9/2012)
This is more of a temporal problem than a recursive problem.
At first glance, I thought so, as well. Then I looked at the values in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2012 at 11:26 pm
Using the provided data except as Temp Tables instead of Table Variables, here's a recursive CTE solution without the Cartesian Product problem. Notice the "HRoot" column which allowed me...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2012 at 11:09 pm
I've not sussed the problem yet but the recursive method is going to get pretty darned slow as Dwain indicated. The recursive CTE essentially causes a cross join (Cartesian...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2012 at 10:10 pm
shannonjk (4/9/2012)
I will put along some sample data here today. Sorry this is not the only critical thing I have to do today! π
Not to worry. Wasn't critical for...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2012 at 9:49 pm
rummings (4/9/2012)
the higher ups are super stingy with disk space.... we have to squeeze out all we can to run the system.
BWAAA-HAAAA!!!! The first mistake was someone telling the higher...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2012 at 8:32 pm
My first step would be to add the recommended missing index. FTS is quite fast when properly indexed. It's really not much more than the output of a...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 9, 2012 at 8:24 pm
Viewing 15 posts - 30,391 through 30,405 (of 59,102 total)