如何获取每个父项上子类别的项目计数？ [英] How to get the item count for sub-categories on each parent?

问题描述

这与以下帖子相关：

The function that retrieves the item counts for each folder (category) is:

ALTER FUNCTION [dbo].[GetFolderReceiptCount]
(
    -- Add the parameters for the function here
    @FolderID bigint
)
RETURNS int
AS
BEGIN

    DECLARE @Return int

    SET @Return = 0

    SELECT 
        --H.ReceiptFolderID, 
        @Return = COUNT(H.ReceiptFolderID)
    FROM
        tbl_ReceiptFolderLnk H
        JOIN tbl_Receipt D ON H.ReceiptID = D.ReceiptID
    WHERE ReceiptFolderID=@FolderID
    GROUP BY
        H.ReceiptFolderID

    -- Return the result of the function
    RETURN @Return      

END

如何更改此值以返回每个父母的计数？

How can this be altered to return counts for each parent?

推荐答案

您应更改函数以返回表变量，或使用存储过程，以便可以获取数据集

You should change the function to return a table variable, or use a stored procedure so that you can get a data set

SQL语句应与此类似：

The SQL Statement should be similar to this:

SELECT 
    H.ReceiptFolderID, COUNT(H.ReceiptFolderID)
FROM
    tbl_ReceiptFolderLnk H
    JOIN tbl_Receipt D ON H.ReceiptID = D.ReceiptID
WHERE ReceiptFolderID=@FolderID
GROUP BY
    H.ReceiptFolderID

这篇关于如何获取每个父项上子类别的项目计数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！