如何计算多个表中的记录数 [英] How to count number of records from multiple table

问题描述

我有一个查询

Hi i have a query

SELECT  tblMaster.Code AS IDRNo,RG.Regno AS RegistrationNo,AD.AdmissionNo,RG.PatientName,BED.BedNo, Dept.Description AS Department, Type =CASE WHEN tblMaster.IDRTypeID=1 THEN 'Medicines' ELSE 'Disposible' END,  tblMaster.InsertedOn AS DateTime,tblEmployee_1.EmployeeName AS ApprovedBy, tblMaster.ApprovedDatetime   FROM DeptInv.dbo.tblIDRMaster AS tblMaster    INNER JOIN  PRS.dbo.tblRegistration AS RG      ON tblMaster.RegNo = RG.Regno INNER JOIN PRS.dbo.tblAdmission AS AD       ON tblMaster.AdmissionNo = AD.AdmissionNo   INNER JOIN TKC.dbo.tblDepartment Dept       ON tblMaster.DepartmentID=Dept.DepartmentID       LEFT OUTER JOIN  TKC.dbo.tblEmployee       ON tblMaster.InsertedBy = TKC.dbo.tblEmployee.EmployeeID     INNER JOIN PRS.dbo.tblBedMaster BED  ON AD.BedMasterID=BED.BedMasterID      LEFT OUTER JOIN  PRS.dbo.tblDischargeStatus       ON AD.DischargeStatusID = PRS.dbo.tblDischargeStatus.DischargeStatusID       LEFT OUTER JOIN TKC.dbo.tblEmployee AS tblEmployee_1       ON tblMaster.Aprovedby = tblEmployee_1.EmployeeID      where tblMaster.Deleted = 0 and IsApproved = 1   AND AD.DischargeStatusID = 2    AND tblMaster.StatusID IN (8,9)

该查询从多个表中获取数据.
现在我想通过使用COUNT函数来计数记录的数量，任何人都可以帮助我，

this query take data from multiple tables.
now i want to count the number of records by using COUNT function, any one help me,

推荐答案

将其存储在临时表中并编写简单的select查询或使用CTE (mssql 2005或更高版本)


http://www.4guysfromrolla.com/webtech/071906-1.shtml [ ^ ]

Store this in a temp table and write simple select query or use CTE (mssql 2005 or above)


http://www.4guysfromrolla.com/webtech/071906-1.shtml[^]

这篇关于如何计算多个表中的记录数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！