如何获取每个父项上子类别的项目计数？

本文介绍了如何获取每个父项上子类别的项目计数？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

这与以下帖子相关：

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