Get Adobe Flash player

Tüm Liste

SELECT StudentNumber as Alan1, StudentName+' '+StudentSurname as ALAN2, JobTel Alan8, GuardianName+' '+GuardianSurname as VELI, ClassDef.ShortName + '-' + D.Value1 as Alan3 FROM Student INNER JOIN ClassDef ON ClassDef.ClassCode=Student.ClassCode LEFT JOIN Definitions as D ON D.Code=Student.DepartmentCode AND D.Type=2 WHERE Student.Deleted=0

Tüm Liste-2

SELECT StudentNumber as Alan1, StudentName+' '+StudentSurname as ALAN2, HomeTel Alan8, GuardianName+' '+GuardianSurname as VELI, ClassDef.ShortName + '-' + D.Value1 as Alan3, Definitions.Value1 as OKUL FROM Student INNER JOIN ClassDef ON ClassDef.ClassCode=Student.ClassCode LEFT JOIN Definitions ON Definitions.Code=Student.SchoolCode AND Definitions.Type=4 LEFT JOIN Definitions as D ON D.Code=Student.DepartmentCode AND D.Type=2 WHERE Student.Deleted=0

Devamsızlık

SELECT dbo.Student.StudentNumber As Alan1, dbo.SchoolContinuity.ContinuityDate As TARIH, dbo.Student.StudentName+' '+dbo.Student.StudentSurname as ALAN2, ClassDef.ShortName + '-' + D.Value1 as Alan3, dbo.Student.JobTEL As Alan8, ( case when dbo.SchoolContinuity.AllDay='1' then 'TAM GÜN' when dbo.SchoolContinuity.HalfDayMorning='1' then 'SABAHTAN YARIM GÜN' when dbo.SchoolContinuity.HalfDayAfternoon='1' then 'ÖĞLEDEN YARIM GÜN' end) as DURUM, dbo.SchoolContinuity.AllDay As TAMGUN, dbo.SchoolContinuity.HalfDayMorning AS SABAHYARIM, dbo.SchoolContinuity.HalfDayAfternoon AS OGLEYARIM FROM dbo.SchoolContinuity INNER JOIN dbo.Student ON dbo.SchoolContinuity.StudentNumber = dbo.Student.StudentNumber INNER JOIN ClassDef ON ClassDef.ClassCode=Student.ClassCode LEFT JOIN Definitions as D ON D.Code=Student.DepartmentCode AND D.Type=2 where dbo.SchoolContinuity.ContinuityDate = CONVERT(DATETIME, '[bastarih]', 103)

Sbs Listesi

SELECT S.StudentNumber as Alan1, S.StudentName+' '+StudentSurname as ALAN2, HomeTel Alan8, GuardianName+' '+GuardianSurname as VELI, ClassDef.ShortName + '-' + D.Value1 as Alan3, EM.ExamName, E.SBSPuan, E.TurkceDogru, E.TurkceYanlis, E.MatematikDogru, E.MatematikYanlis, E.FenDogru, E.FenYanlis, E.SosyalDogru, E.SosyalYanlis, E.YabanciDilDogru, E.YabanciDilYanlis, E.DinDogru, E.DinYanlis FROM Student AS S INNER JOIN ClassDef ON ClassDef.ClassCode=S.ClassCode LEFT JOIN Definitions as D ON D.Code=S.DepartmentCode AND D.Type=2 INNER JOIN ExamSbs AS E ON E.StudentNumber = S.StudentNumber and ExamNo=[istenensinavkodu] INNER JOIN ExamMaster EM ON EM.ExamId= E.ExamNo WHERE S.Deleted=0

TYT Listesi

SELECT S.StudentNumber AS Alan1, S.StudentName + ' ' + StudentSurname AS ALAN2, HomeTel Alan8, GuardianName + ' ' + GuardianSurname AS VELI, ClassDef.ShortName + '-' + D.Value1 AS Alan3, (SELECT ExamName from ExamMaster Where ExamNo=[istenensinavkodu]) SinavAdi , (SELECT MIN(Gdegree) From ExamPointResult WHERE ExamNo=[istenensinavkodu] AND StudentNumber=S.StudentNumber) AS Derece, (SELECT MIN(PointValue) From ExamPointResult WHERE ExamNo=33 AND StudentNumber=S.StudentNumber) AS Puan, E.TurNet, E.Sos1Net, E.MatNet, E.Fen1Net, (E.TurNet + E.Sos1Net + E.MatNet + E.Fen1Net ) AS ToplamNet FROM Student AS S INNER JOIN ClassDef ON ClassDef.ClassCode = S.ClassCode LEFT JOIN Definitions AS D ON D.Code = S.DepartmentCode AND D.Type = 2 INNER JOIN ExamOss AS E ON E.StudentNumber = S.StudentNumber AND ExamNo = [istenensinavkodu] INNER JOIN ExamMaster EM ON EM.ExamNo = E.ExamNo WHERE S.Deleted = 0

Sınav Listesi

Select CONVERT(VARCHAR(50),examNo) as SinavKodu, examName as SinavAdi From ExamMaster