This book was really rushed. We tried to use it for an in-house class and spent most of our time debugging the samples.
--Angus

Angus:
Sorry to hear that. Can you give us a couple of specific examples to look at, or specific chapters you were in that caused trouble? I'm sure Scott would like to get any feedback you have.

Jim Minatel
Senior Acquisitions Editor
Wiley Technology Publishing
WROX Press
Blog: http://wroxblog.typepad.com/
Jim's Book of the week: No book this week - Donate to the Red Cross!

Hi Angus,

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?

Angus (and all),

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.

Scott

I bought the book today (5/20), no errata on this site, so where's the fixes for the incorrect code? The last post here was a couple of months ago.

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.

Scott

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.

Scott

Hi,

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.

Thanks
roy

<LinkedMembers>
    <Member>
      <MemHeader>
        <SrcCode>B</SrcCode>
        <EID>100000</EID>
        <MemID>HSG-200</MemID>
      </MemHeader>
      <AttributeList>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>First</AttributeName>
          <Currentvalue>Lee</Currentvalue>
        </Item>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>Middle</AttributeName>
          <Currentvalue>Marvin</Currentvalue>
        </Item>
        <Item>
          <Groupname>Name</Groupname>
          <AttributeName>Last</AttributeName>
          <Currentvalue>Bruised</Currentvalue>
        </Item>
      </AttributeList>
    </Member>
    <Member>
      <MemHeader>
        <SrcCode>C</SrcCode>
        <EID>120202</EID>
        <MemID>CTX-300</MemID>
      </MemHeader>
      <AttributeList>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>First</AttributeName>
          <Currentvalue>Barry</Currentvalue>
        </Item>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>Middle</AttributeName>
          <Currentvalue>M</Currentvalue>
        </Item>
        <Item>
          <Groupname>NAME</Groupname>
          <AttributeName>Last</AttributeName>
          <Currentvalue>Humphries</Currentvalue>
        </Item>
        <Item>
          <Groupname>ADDRESS</Groupname>
          <AttributeName>Line1</AttributeName>
          <Currentvalue>40 Fore Street</Currentvalue>
        </Item>
      </AttributeList>
    </Member>
  </LinkedMembers>