|
|
|
|
For dig, der er begynder i brugen af regneark, og som ønsker at lære de grundlæggende funktioner i Excel. Følgende emner gennemgås:
- oprettelse af regneark og indsætning af formler
- formatering
- brug af funktioner
- diagrammer
|
|
|
|
|
|
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 = 259630) AND (dbo.TBLsite_calender.CalenderDate >= CONVERT(datetime,'2017-9-20', 102)) ORDER BY dbo.TBLSite_relation.relationSortInt, dbo.TBLsite_calender.CalenderDate, dbo.TBLsite_calender.CalenderTime
|
