daily pastebin goal
94%
SHARE
TWEET

Untitled

a guest Nov 20th, 2017 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT DISTINCT jbInternational.idnumber
  2.     ,jbInternational.lastname
  3.     ,jbInternational.firstname
  4.     ,jbInternational.midname
  5.     ,jbInternational.campus
  6.     ,jbInternational.universityid
  7.     ,jbInternational.sevisid
  8.     ,jbInternational.citizenship
  9.     ,jbInternational.immigrationstatus
  10.     ,sevisI20Program.prgEndDate
  11. FROM jbInternational
  12. INNER JOIN configAlertOrgCode ON jbInternational.orgCode = configAlertOrgCode.orgCode
  13.     AND configAlertOrgCode.alertGroup = 'Students'
  14. INNER JOIN viewAlertCampusF1 ON jbInternational.campus = viewAlertCampusF1.campus
  15.     AND viewAlertCampusF1.alertGroup = 'Students'
  16. INNER JOIN sevisI20Program ON jbInternational.idnumber = sevisI20Program.idnumber
  17.     AND jbInternational.sevisid = sevisI20Program.sevisid
  18.     AND sevisI20Program.STATUS IN (
  19.         SELECT systemValue
  20.         FROM configFilterSEVISStatusActive
  21.         )
  22. WHERE sevisI20Program.prgEndDate BETWEEN DateAdd(day, 30, GETDATE())
  23.         AND DateAdd(day, 60, getDate())
  24.     AND idnumber = 2302
  25. ORDER BY jbInternational.lastname
  26.     ,jbInternational.firstname
  27.     ,jbInternational.midname
RAW Paste Data
Top