|
|
|
|
Book et gratis og uforpligtende møde, hvor vi sammen finder den bedste og mest optimale løsning for lige netop jeres virksomhed. Besøget er gratis og uforpligtende.
Vi kan inspirere om mulighederne for en optimal løsning, bidrage til behovsafklaring, planlægning af kompetenceudvikling og uddannelsesplan samt sørge for, at den mest fordelagtige finansieringsordning kommer på plads.
|
Virksomhedskonsulenter - CKU
Hanne Christensen
Chefkonsulent
Tlf.: 27886018
|
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 (11075,11228,11074,12244,11073,11072)) AND (dbo.TBLsite_calender.CalendarFreeText = '') AND (dbo.TBLSite_relation.fromModuleGuid = 25) AND (dbo.TBLSite_relation.fromSubModuleGuid = 0) AND (dbo.TBLSite_relation.fromSiteGuid IN (11075,11228,11074,12244,11073,11072)) AND (dbo.TBLSite_relation.toSiteGuid IN (11075,11228,11074,12244,11073,11072)) 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 = 254424) AND (dbo.TBLsite_calender.CalenderDate >= CONVERT(datetime,'2017-6-22', 102)) ORDER BY dbo.TBLSite_relation.relationSortInt, dbo.TBLsite_calender.CalenderDate, dbo.TBLsite_calender.CalenderTime
|
