Вход на сайт
SQL
715 просмотров
Перейти к просмотру всей ветки
в ответ Murr 02.06.11 20:00
да, работаю с XML. Полный скрипт:
-------------------------------------------
SELECT Id, Name, Workability,
(SELECT Id, Name, Workability,
(SELECT Id, Name, Workability
FROM ProductItem item
WHERE (sub.Id = item.SubCategoriesId) FOR XML AUTO, TYPE)
FROM SubCategories sub
WHERE (sub.CategoriesId = cat.Id)FOR XML AUTO, TYPE)
FROM Categories cat
FOR XML AUTO, ROOT('block')
-------------------------------------------
MS SQL 2008
10.0.1600.22 ((SQL_PreRelease).080709-1414
4000 rows
-------------------------------------------
SELECT Id, Name, Workability,
(SELECT Id, Name, Workability,
(SELECT Id, Name, Workability
FROM ProductItem item
WHERE (sub.Id = item.SubCategoriesId) FOR XML AUTO, TYPE)
FROM SubCategories sub
WHERE (sub.CategoriesId = cat.Id)FOR XML AUTO, TYPE)
FROM Categories cat
FOR XML AUTO, ROOT('block')
-------------------------------------------
MS SQL 2008
10.0.1600.22 ((SQL_PreRelease).080709-1414
4000 rows