I am make it. Maybe someone will need
1. Create the function NB_Store_GetCategoryChildIDs:
CREATE FUNCTION {databaseOwner}[NB_Store_GetCategoryChildIDs] (@CategoryID int)
RETURNS @tbl TABLE (number int NOT NULL) AS
BEGIN
DECLARE @pos int
INSERT @tbl (number) VALUES (@CategoryID)
INSERT @tbl (number)
SELECT [CategoryID]
FROM {databaseOwner}[{objectQualifier}NB_Store_Categories]
WHERE [ParentCategoryID] = @CategoryID
SET @pos = 1
WHILE @pos <= 4
BEGIN
INSERT @tbl (number)
SELECT [CategoryID]
FROM {databaseOwner}[{objectQualifier}NB_Store_Categories],
@tbl ss
WHERE [ParentCategoryID] = ss.number
SET @pos = @pos + 1
END
RETURN
END
2. Modify the procedures NEvoweb_NB_Store_Products_GetList, NEvoweb_NB_Store_Products_GetListSize
from
if (@CategoryID > 0 and @Filter = '')
begin
set @SQL = @SQL + ' and PC.CategoryID = ' + convert(nvarchar(5),@CategoryID)
end
to
if (@CategoryID > 0 and @Filter = '')
begin
set @SQL = @SQL + ' and PC.CategoryID IN (select * from NB_Store_GetCategoryChildIDs(' + convert(nvarchar(5),@CategoryID) + '))'
end
