use DST18000Suffix --Active Student Count SELECT COUNT(*),SC FROM STU WHERE DEL = 0 --AND NG < 13 and sc < 101 GROUP BY SC ORDER BY SC --Review Schools - LOC SELECT * FROM LOC --Schools to SKIP () - --SC IN (220,230,240,250,261,270,271,272,280,290,311) Summer Schools (312,351) --Inactive School - 999 --Review Last day of school select * from day order by dt desc --Review NS = 0 --Four students 4107988,4109972,4109978,4109977 --Three were pre-enrolled SELECT SC AS [School],NS AS [Next School],ID AS [StudentID],SN AS [STU#], GR AS [GR],NG AS [Next GR], CU AS [TCH/CNSLR],NT AS [Next TCH], SP AS [Prog],NSP AS [Next Prog], AP1 AS [Att Prog],NP1 AS [Next Att Prog], AP2 AS [Att Prog2],NP2 AS [Next Att Prog2], RS AS [Resident SC],NRS AS [Next Resident SC], IT AS [Int Transfer],NIT AS [Next Int Transfer], ITD AS [Int Trans District],NTD AS [Next Int Trans District], EOY AS [End of Year], HSG AS [Grad Type], DG AS [Grad Date], TG AS [Status], LN AS [Last Name], FN AS [First Name], LD AS [Exit Date], DEL AS [DEL Tag] FROM STU where (tg = ' ' or tg = '*') and del = 0 and ns = 0 and SC < 101 AND NG < 13
Modified on: Mon, Jun 15, 2020 at 12:34 PM
Did you find it helpful?Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.