Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. select Obj.regcode,count(*)
  2. FROM dbo.Objecten Obj
  3. INNER JOIN dbo.Dossiers Dos ON obj.objectnr=Dos.objectnr
  4. WHERE Dos.plan_gereed between '2014-01-01' and '2014-02-01'
  5. group by obj.regcode having count(*) > 1
  6.  
  7. SELECT obj.regcode, Dos.dossiernr
  8. FROM dbo.objecten obj,
  9. dbo.Dossiers Dos
  10. WHERE obj.regcode IN ( select Obj.regcode,count(*)
  11. FROM dbo.Objecten Obj
  12. INNER JOIN dbo.Dossiers Dos ON obj.objectnr=Dos.objectnr
  13. WHERE Dos.plan_gereed between '2014-01-01' and '2014-02-01'
  14. group by obj.regcode
  15. having count(*) > 1 )
  16. AND obj.objectnr=Dos.objectnr
  17.  
  18. SELECT obj.regcode, Dos.dossiernr FROM dbo.objecten obj, dbo.Dossiers Dos WHERE obj.regcode IN ( select Obj.regcode FROM dbo.Objecten Obj INNER JOIN dbo.Dossiers Dos ON obj.objectnr=Dos.objectnr WHERE
  19. Dos.plan_gereed between '2014-01-01' and '2014-02-01' group by obj.regcode having count(*) > 1 ) AND obj.objectnr=Dos.objectnr
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement