code_junkie

Unfamiliar character in SQL statement

Nov 11th, 2011
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. SELECT
  2. CASEID,
  3. GetNoteText(CASEID)
  4. FROM
  5. (
  6. SELECT
  7. CASEID
  8. FROM
  9. ATTACHMENTS
  10. GROUP BY
  11. CASEID
  12. ) i
  13. GO
  14.  
  15. SELECT
  16. c.CASEID, c.CASE_NAME,
  17. a.COUNT AS ATTACHMENTSCOUNT, o.COUNT as OTHERCOUNT,
  18. dbo.GetNoteText(c.CASEID)
  19. FROM CASES c
  20. LEFT OUTER JOIN
  21. (
  22. SELECT
  23. CASEID, COUNT(*) AS COUNT
  24. FROM
  25. ATTACHMENTS
  26. GROUP BY
  27. CASEID
  28. ) a
  29. ON a.CASEID = c.CASEID
  30. LEFT OUTER JOIN
  31. (
  32. SELECT
  33. CASEID, COUNT(*) AS COUNT
  34. FROM
  35. OTHER
  36. GROUP BY
  37. CASEID
  38. ) o
  39. ON o.CASEID = c.CASEID
  40.  
  41. SELECT DT1.CASEID, GetNoteText(DT1.CASEID)
  42. FROM (
  43. SELECT CASEID
  44. FROM ATTACHMENTS
  45. GROUP BY CASEID
  46. ) AS DT1 (CASEID);
Add Comment
Please, Sign In to add comment