You are currently viewing the BOOK: Professional SQL Server 2005 XML ISBN: 0-7645-9792-2 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
Yes, please send the examples you were using. The exmaples in this book were checked multiple times for correctness so I would be very interested in knowing what examples you were using. Also, are you using the released version of SQL Server 2005?
I have indeed found a number of instances where the examples do not work. I am currently in the process of fixing the code and will repost the code within the next couple of days. Thank you for bringing this to our attention.
New code was posted a month or so ago, so if you download the code you should have the new code. Also, let me know if you find any other issues so we can get those up there as well. Keep in mind that the code was written with an early edition of Beta 2. Thank you for your email. It is greatly appreciated.
Thanks for the prompt reply, I fully understand the issue dealing with beta editions. When you stated you would repost the code I took it to mean here in this forum. Good to hear the corrections have been made. :D
Yes, I should have posted here when the new code was posted. My apologies, and I'll be more proactive on that. Thanks for purchasing the book. I hope you like it, and again, please let me know if you find any other issues.
The book does not show any kind of samples of shredding xml to hierarchical tables with different primary keys.
I thought it is a poor attempt by the author.
Could Scott at least give an example now please?
say shredding the attached xml to 2 tables memberheader and attributes both of which contain primary keys i.e. memHeaderID. Attributes hold a key to memHeaderID.