?? bugnet_bug_getbugfixedinversioncountbyproject.sql
字號:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BugNet_Bug_GetBugFixedInVersionCountByProject]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[BugNet_Bug_GetBugFixedInVersionCountByProject]
GO
CREATE PROCEDURE BugNet_Bug_GetBugFixedInVersionCountByProject
@ProjectId int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT v.Name, COUNT(nt.FixedInVersionId) AS Number, v.VersionID
FROM Version v
LEFT OUTER JOIN (SELECT FixedInVersionId
FROM Bug b
WHERE (b.StatusID <> 4) AND (b.StatusID <> 5)) nt ON v.VersionID = nt.FixedInVersionId
WHERE (v.ProjectID = @ProjectId)
GROUP BY v.Name, v.VersionID,v.SortOrder
ORDER BY v.SortOrder ASC
END
GO
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -