The use of PATH is amazing.

Just as on previous post of this serie, here is the code with comments in spanish.

PS: the links to the code files are broken, maybe...

Things are getting better and better. And with the comments on the discussion even better. Last comments and questions from bdba where helpfull too as my final goal is to...

In case anyone mayneeded, here is the same post, but with comments in spanish, enjoy

CREATE TABLE [dbo].[OrderDetails](

[OrderDetailID] [int] IDENTITY(1,1) NOT NULL,[OrderNumber] VARCHAR(10) NOT NULL,

[ItemNumber] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[Qty] [int] NULL,[Rate]...

I will be forever thankfull for this post. I have gone through all the previous posts about XML handling and this one is exactly what I was looking for. Nevertheless...

Whooaa!! great improvement using XQuery. Will follow the XQuery workbench proposed by you on beyondrelational.com website to get a better understanding on how it works. I get confused using the...

Great, just tested, everything ok, had some collation issues on my database but is ok now.

I received several "invalid name error" related to ItemNumber/itemNumber, OrderNumber/orderNumber, OrderHeader/orderHeader. Don't know exactly if...

Hi, good improvement in relation to 1rst part of the series, now the procedure receives only one parameter and filling the tables is now equal on the header and the...

Hi, very good series of articles, I'm starting from the first one, hope once reach the last one of the serie I can apply all I learned on MSSQL 2008R2...