Viewing 15 posts - 22,891 through 22,905 (of 26,490 total)
Jeff Moden (1/21/2009)
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,...
January 21, 2009 at 7:14 pm
As it may difficult to critique myself. I decided that I'll let any of the top 15 forum leaders have the honor of pointing out my mistakes. I...
January 21, 2009 at 7:09 pm
Define a table variable, then insert the error information into the table variables first. After you issue the rollback, then insert the information from the table variable into your...
January 21, 2009 at 3:35 pm
Matt Miller (1/21/2009)
Lynn Pettis (1/21/2009)
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...
January 21, 2009 at 3:29 pm
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
Viewing 15 posts - 22,891 through 22,905 (of 26,490 total)