Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- CASEID,
- GetNoteText(CASEID)
- FROM
- (
- SELECT
- CASEID
- FROM
- ATTACHMENTS
- GROUP BY
- CASEID
- ) i
- GO
- SELECT
- c.CASEID, c.CASE_NAME,
- a.COUNT AS ATTACHMENTSCOUNT, o.COUNT as OTHERCOUNT,
- dbo.GetNoteText(c.CASEID)
- FROM CASES c
- LEFT OUTER JOIN
- (
- SELECT
- CASEID, COUNT(*) AS COUNT
- FROM
- ATTACHMENTS
- GROUP BY
- CASEID
- ) a
- ON a.CASEID = c.CASEID
- LEFT OUTER JOIN
- (
- SELECT
- CASEID, COUNT(*) AS COUNT
- FROM
- OTHER
- GROUP BY
- CASEID
- ) o
- ON o.CASEID = c.CASEID
- SELECT DT1.CASEID, GetNoteText(DT1.CASEID)
- FROM (
- SELECT CASEID
- FROM ATTACHMENTS
- GROUP BY CASEID
- ) AS DT1 (CASEID);
Add Comment
Please, Sign In to add comment