Gridview data is missing but stored procedure is showing

Having a gridview does not produce the record as showing below :

1)
select smp.id from StudentModulePeriod smp
INNER JOIN Lesson l ON smp.lid = l.id
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id
INNER JOIN Trainer tr ON smp.trid = tr.id
WHERE DATEPART(month, smp.onmonth) = 1 AND
l.lessonno = 'L12' AND m.modulename = 'A+' AND p.intakename = 'December 2011'

= produces 185

2)
Select * from StudentModulePeriod WHERE id=185

3)
select smp.starttime from StudentModulePeriod smp
INNER JOIN Lesson l ON smp.lid = l.id
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id
INNER JOIN Trainer tr ON smp.trid = tr.id
WHERE DATEPART(month, smp.onmonth) = 1 AND
l.lessonno = 'L12' AND m.modulename = 'A+' AND p.intakename = 'December 2011'

= produces 30-01-2001


above query generates record,
but in gridview is not showing this record with the long stored procedure in code attached

store procedure
---------------
USE [iDash5]
GO
/****** Object:  StoredProcedure [dbo].[spViewStudentTimetableByMonth]    Script Date: 06/15/2011 16:05:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[spViewStudentTimetableByMonth]

@onmonth int,

@intake varchar(100)


	-- 
AS

;with CTE as (
select l.lessonno as lessonno,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom

from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L01' 

UNION

select l.lessonno as lessonno,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom


from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L02' 


UNION

select l.lessonno as lessonno,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom


from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L03' 


UNION

select l.lessonno as lessonno,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,

(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom

from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L04'


UNION

select l.lessonno as lessonno,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom

from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L05'


UNION

select l.lessonno as lessonno,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id  from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom


from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L06'

UNION



select l.lessonno as lessonno,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom
from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L07'



UNION

select l.lessonno as lessonno,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom

from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L08'



UNION

select l.lessonno as lessonno,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom
from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09'



UNION

select l.lessonno as lessonno,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom
from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L09'



UNION

select l.lessonno as lessonno,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom

from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L10'



UNION

select l.lessonno as lessonno,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom

from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L11'



UNION

select l.lessonno as lessonno,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom

from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L12'



UNION

select l.lessonno as lessonno,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3ID,

(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9ID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusID,
(select smp.id from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusID,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M1' AND p.intakename = @intake
) as M1DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M2' AND p.intakename = @intake
) as M2DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M3' AND p.intakename = @intake
) as M3DateClassRoom,

(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M4' AND p.intakename = @intake
) as M4DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M5' AND p.intakename = @intake
) as M5DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M6' AND p.intakename = @intake
) as M6DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M7' AND p.intakename = @intake
) as M7DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M8' AND p.intakename = @intake
) as M8DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9Date,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'M9' AND p.intakename = @intake
) as M9DateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'A+' AND p.intakename = @intake
) as AplusDateClassRoom,
(select smp.starttime from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDate,
(select smp.classroom from StudentModulePeriod smp 
INNER JOIN Lesson l ON smp.lid = l.id 
INNER JOIN Module m ON smp.mid = m.id
INNER JOIN Period p ON smp.pid = p.id

INNER JOIN Trainer tr ON smp.trid = tr.id 
WHERE DATEPART(month, smp.onmonth) = @onmonth AND 
l.lessonno = 'L13' AND m.modulename = 'N+' AND p.intakename = @intake
) as NplusDateClassRoom

from Lesson l),
CTE2 as (select *,ROW_NUMBER() over (PARTITION BY lessonno order by M1ID desc) rn from CTE)
select * from CTE2 where rn = 1

aspx
----
  if (dRow.AplusDate == DateTime.MinValue || dRow.AplusDate == SqlDateTime.Null || e.Row.Cells[10].Text == "01/01/0001")
            {
                e.Row.Cells[10].Text = String.Empty;
            }
            else if (dRow.AplusDate != DateTime.MinValue || dRow.AplusDate != SqlDateTime.Null || e.Row.Cells[10].Text != "01/01/0001")
            {
                DataSet ds = StudentTimetable.getStudentModulePeriod_ByID(dRow.AplusID);
                e.Row.Cells[10].Text = dRow.AplusDate.ToString("dd/MM/yyyy");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    if (ds.Tables[0].Rows[0]["classroom"] != DBNull.Value)
                    {
                        Label lbl = new Label();
                        lbl.Text = ds.Tables[0].Rows[0]["classroom"].ToString();
                        lbl.ForeColor = System.Drawing.Color.Blue;
                        e.Row.Cells[10].Text = e.Row.Cells[10].Text + "- " + lbl.Text;
                    }

                    if (Convert.ToBoolean(ds.Tables[0].Rows[0]["BufferDay"]) == true)
                    {
                        //  e.Row.Cells[1].Text = e.Row.Cells[1].Text + " BD";
                        e.Row.Cells[10].Text += " - BD";
                    }

                    if (Convert.ToBoolean(ds.Tables[0].Rows[0]["EvaluationTest"]) == true)
                    {
                        e.Row.Cells[10].Text += " - ET";
                    }

                    if (Convert.ToBoolean(ds.Tables[0].Rows[0]["PracticalTest"]) == true)
                    {
                        //  e.Row.Cells[1].Text = e.Row.Cells[1].Text + " BD";
                        e.Row.Cells[10].Text += " - PT";
                    }

                    if (Convert.ToBoolean(ds.Tables[0].Rows[0]["FinalTest"]) == true)
                    {
                        e.Row.Cells[10].Text += " - FT";
                    }
                }

            }

Select allOpen in new window