|
|
-
Alejandro Mesa Commented 3 Years ago through Blogs | 1 Point
Hi Jacob,
Here is another approach to get same result. This approach uses the edge table from OPENXML function.
USE tempdb;
GO
CREATE TABLE #T (
id bigint NOT NULL PRIMARY KEY,
parentid bigint NULL,
nodetype int NOT NULL, -- 1 - element, 2 - ...
|
-
Alejandro Mesa Commented 3 Years ago through Blogs | 1 Point
Hi Jacob,
Here is another approach to get same result. This approach uses the edge table from OPENXML function.
USE tempdb;
GO
CREATE TABLE #T (
id bigint NOT NULL PRIMARY KEY,
parentid bigint NULL,
nodetype int NOT NULL, -- 1 - element, 2 - ...
|
-
Alejandro Mesa Commented 3 Years ago through Blogs | 1 Point
Hi Jacob,
This is really a good exercise. I wish we could have an xml method to return the same edge table as when we use OPENXML without "WITH", or the node table produced by the iterator "Table Valued Function - XML Reader " when you use the nodes...
|
-
Alejandro Mesa Commented 3 Years ago through Blogs | 1 Point
Hi Jacob,
This is really a good exercise. I wish we could have an xml method to return the same edge table as when we use OPENXML without "WITH", or the node table produced by the iterator "Table Valued Function - XML Reader " when you use the nodes...
|