You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
23 lines
456 B
23 lines
456 B
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
|
|
CREATE VIEW BucketCounts AS
|
|
SELECT CrashInstances.BucketId,
|
|
Followup,
|
|
COUNT (DISTINCT CrashInstances.CrashId) AS Instances,
|
|
CrashBuckets.BugId
|
|
FROM CrashBuckets, CrashInstances
|
|
WHERE CrashBuckets.BucketId = CrashInstances.BucketId
|
|
GROUP BY CrashBuckets.Followup, CrashInstances.BucketId
|
|
|
|
|
|
|
|
GO
|
|
SET QUOTED_IDENTIFIER OFF
|
|
GO
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|