Viewing 8 posts - 1 through 8 (of 8 total)
Jeff, you've come up with a nice, simple method for doing this. It made me go back and look at how I had coded it in my application. My code...
November 16, 2009 at 6:34 am
Could you kindly post the DDL for #myinfo and the test data you used for this article?
Sure.
The data used to populate this table came from several tables, and our...
October 21, 2009 at 11:53 am
Thanks, Paul; you made my day!
Phil: I also started looking for a replacement for openXml. One suggestion was to use nodes, but in our system we have a variety of...
October 21, 2009 at 6:33 am
The xml that is input to this is usually small: a couple of dozen lines. It takes 6 milliseconds to populate the @xmlEdgeTbl via the openxml.
When I try this with...
October 19, 2009 at 12:38 pm
Is there a DB setting that we need to set in order to execute this code? I cannot get it to run even if I remove the CREATE PROCEDURE statement...
October 5, 2009 at 9:48 am
Please use the code at the top of this discussion page instead. That will fix the problem.
October 5, 2009 at 3:47 am
Thanks, Lynn! Here's a possible minor tweak that I think makes one less trip through the loop (unless the total number of rows we're deleting is an exact multiple of...
September 15, 2009 at 7:51 am
This is a very useful idea, but it seems that there is a bug in the code. If you run the "usage" example at the top of the code, you...
August 12, 2009 at 11:06 am
Viewing 8 posts - 1 through 8 (of 8 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy