|
|
|
|
Såfremt du ved afslutningen af dit grundforløb ikke har fundet en elevplads, kan du søge om optagelse i skolepraktikken. Uddannelsesgarantien sikrer, at du som minimum kan gennemføre en merkantil uddannelse med opstart i skolepraktikken og eventuelt med restelevtid i en virksomhed uden for skolen. Skolepraktikken er et tilbud som kræver, at du opfylder visse betingelser for at blive optaget.
|
|
SELECT dbo.TBLsite_calender.CalenderGuid,TBLsite_calender.CalenderTicketCount,dbo.TBLsite_calender.logicalName, dbo.TBLsite_calender.CalenderName, dbo.TBLsite_calender.CalenderText, dbo.TBLsite_calender.CalenderTime, dbo.TBLsite_calender.CalenderDate, dbo.TBLsite_calender.pictureName, dbo.TBLsite_calender.picturePath, dbo.TBLsite_calender.SiteGuid, dbo.TBLSite_relation.relationName, dbo.TBLSite_relation.relationDescription FROM dbo.TBLSite_relation INNER JOIN dbo.TBLsite_calender ON dbo.TBLSite_relation.toEntityGuid = dbo.TBLsite_calender.CalenderGuid WHERE (dbo.TBLsite_calender.SiteGuid IN (11072,11073,11074,11075,11228,12244,11869)) AND (dbo.TBLsite_calender.CalendarFreeText = '') AND (dbo.TBLSite_relation.fromModuleGuid = 25) AND (dbo.TBLSite_relation.fromSubModuleGuid = 0) AND (dbo.TBLSite_relation.fromSiteGuid IN (11072,11073,11074,11075,11228,12244,11869)) AND (dbo.TBLSite_relation.toSiteGuid IN (11072,11073,11074,11075,11228,12244,11869)) AND (dbo.TBLSite_relation.toModuleGuid = 28) AND (dbo.TBLSite_relation.toSubModuleGuid = 0) AND (dbo.TBLSite_relation.relationStartDate <= GETDATE() OR dbo.TBLSite_relation.relationStartDate IS NULL) AND (dbo.TBLSite_relation.relationEndDate >= GETDATE() OR dbo.TBLSite_relation.relationEndDate IS NULL) AND (dbo.TBLSite_relation.fromEntityGuid = 253084) AND (dbo.TBLsite_calender.CalenderDate >= CONVERT(datetime,'2017-6-23', 102)) ORDER BY dbo.TBLSite_relation.relationSortInt, dbo.TBLsite_calender.CalenderDate, dbo.TBLsite_calender.CalenderTime
|
