Viewing 15 posts - 22,891 through 22,905 (of 26,486 total)
Why not define a temporary table and the use INSERT INTO #TempTable EXEC dbo.MyStoredProc. Then use the temporary table for what ever you need to do?
January 21, 2009 at 3:18 pm
RBarryYoung (1/21/2009)
David Webb (1/21/2009)
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Yes, and HIT...
January 21, 2009 at 3:13 pm
It took 4 hours and 21 posts before he finally provided anything useful (but still missing the expected results) to even start coming up with anything useful. Took less...
January 21, 2009 at 3:03 pm
David Webb (1/21/2009)
I've been following the other thread mentioned above. Based on the expected outcome he just posted (which had exactly 0 relation to the sample data provided), if...
January 21, 2009 at 2:51 pm
I don't have SQL Server 2008 (yet), but could the problem be the following:
SET @hid = HIERARCHYID::GetRoot();
If I counted right this would be line 12.
January 21, 2009 at 2:45 pm
When a resolution you have, be sure to post back with it.
There may be others with similiar issues as you.
January 21, 2009 at 2:41 pm
Not ready is he. Be back he may be.
January 21, 2009 at 2:38 pm
But I need to be able to get from point A to point B, and point B in this case has no resemblance to point A. Show me what...
January 21, 2009 at 2:28 pm
Bob Hovious (1/21/2009)
Grant Fritchey (1/21/2009)
It sounds more like a Monty Python sketch to me.
Hmmmmm......
----------------------------------------------------
"This query is dead."
"No, it's merely stunned. See, it's using a cursor...."
"It's written in Norwegian SQL...
January 21, 2009 at 2:22 pm
Okay, I am having a disconnect. I can't figure out how you are getting from here:
INSERT INTO #apples
(win_id, [Month], Outcome, Staff, Disp,County,[Year])
SELECT...
January 21, 2009 at 2:19 pm
DavidB (1/21/2009)
Lynn Pettis (1/21/2009)
hmmm, Got "it" I think he has!
Nice job Lynn! There were times looking at that one that I wanted to hit MY head with the keyboard but...
January 21, 2009 at 2:15 pm
Dennis D. Allen (1/21/2009)
Yes that does work and is a fine workaround.
I want to understand why this does not work as it should work correctly and the...
January 21, 2009 at 2:13 pm
Unfortunately, no. Using your sample data, what would you like to see as output.
Input --> Process --> Output.
You have given me the Input, give me the Output, and I'll...
January 21, 2009 at 1:58 pm
Use the Force Luke...
Actually, nothing wrong with posting an answer that's already been posted. One thing you'll see is a difference in formating styles.
January 21, 2009 at 1:46 pm
Viewing 15 posts - 22,891 through 22,905 (of 26,486 total)