Hier gewittert es ohne Ende aber es fällt nichts. Bis auf der Bitcoin Kurs. :D
crystal reports?Quote:
in der tat erstelle ich gerade crystal reports :bandit:
jo sieht so ausQuote:
SELECT "Appointment"."StartDate", "Appointment"."EndDate", "Appointment"."Deleted", "Appointment"."AppointmentID", "Client"."ClientLastTimeReached", "Client_1"."ClientLastTimeReached", "Appointment"."Name", "OrganizationUnit"."Name", "OrganizationUnit_1"."Name", "Client"."Name", "Client_1"."Name", "AppointmentContent"."ContentType", "File"."Name", "Client"."Status", "Client_1"."Status"
FROM ((((((("DCS"."dbo"."OrganizationUnit" "OrganizationUnit" INNER JOIN "DCS"."dbo"."Appointment" "Appointment" ON "OrganizationUnit"."OrganizationUnitID"="Appointment"."OrganizationUnitID") LEFT OUTER JOIN "DCS"."dbo"."Client" "Client" ON "OrganizationUnit"."OrganizationUnitID"="Client"."OrganizationUnitID") LEFT OUTER JOIN "DCS"."dbo"."AppointmentContent" "AppointmentContent" ON "Appointment"."AppointmentID"="AppointmentContent"."AppointmentID") LEFT OUTER JOIN "DCS"."dbo"."OrganizationUnitGroup" "OrganizationUnitGroup" ON "Appointment"."OrganizationUnitID"="OrganizationUnitGroup"."ParentOrganizationUnitID") LEFT OUTER JOIN "DCS"."dbo"."AppointmentContentFile" "AppointmentContentFile" ON "AppointmentContent"."AppointmentContentID"="AppointmentContentFile"."AppointmentContentID") LEFT OUTER JOIN "DCS"."dbo"."File" "File" ON "AppointmentContentFile"."FileID"="File"."FileID") LEFT OUTER JOIN "DCS"."dbo"."OrganizationUnit" "OrganizationUnit_1" ON "OrganizationUnitGroup"."OrganizationUnitID"="OrganizationUnit_1"."OrganizationUnitID") LEFT OUTER JOIN "DCS"."dbo"."Client" "Client_1" ON "OrganizationUnit_1"."OrganizationUnitID"="Client_1"."OrganizationUnitID"
WHERE ("Appointment"."StartDate"<{ts '2017-07-19 00:00:00'} AND "Appointment"."EndDate">={ts '2017-07-19 00:00:01'} OR "Appointment"."StartDate">={ts '2017-07-19 00:00:00'} OR ("Appointment"."StartDate">={ts '2017-07-19 00:00:00'} AND "Appointment"."StartDate"<{ts '2017-07-20 00:00:00'}) OR "Appointment"."StartDate"<{ts '2017-07-19 00:00:01'}) AND "Appointment"."Deleted"=0
dachte meinst den designerQuote:
jo sieht so aus
PHP Code:SELECT "Appointment"."StartDate", "Appointment"."EndDate", "Appointment"."Deleted", "Appointment"."AppointmentID", "Client"."ClientLastTimeReached", "Client_1"."ClientLastTimeReached", "Appointment"."Name", "OrganizationUnit"."Name", "OrganizationUnit_1"."Name", "Client"."Name", "Client_1"."Name", "AppointmentContent"."ContentType", "File"."Name", "Client"."Status", "Client_1"."Status"
FROM ((((((("DCS"."dbo"."OrganizationUnit" "OrganizationUnit" INNER JOIN "DCS"."dbo"."Appointment" "Appointment" ON "OrganizationUnit"."OrganizationUnitID"="Appointment"."OrganizationUnitID") LEFT OUTER JOIN "DCS"."dbo"."Client" "Client" ON "OrganizationUnit"."OrganizationUnitID"="Client"."OrganizationUnitID") LEFT OUTER JOIN "DCS"."dbo"."AppointmentContent" "AppointmentContent" ON "Appointment"."AppointmentID"="AppointmentContent"."AppointmentID") LEFT OUTER JOIN "DCS"."dbo"."OrganizationUnitGroup" "OrganizationUnitGroup" ON "Appointment"."OrganizationUnitID"="OrganizationUnitGroup"."ParentOrganizationUnitID") LEFT OUTER JOIN "DCS"."dbo"."AppointmentContentFile" "AppointmentContentFile" ON "AppointmentContent"."AppointmentContentID"="AppointmentContentFile"."AppointmentContentID") LEFT OUTER JOIN "DCS"."dbo"."File" "File" ON "AppointmentContentFile"."FileID"="File"."FileID") LEFT OUTER JOIN "DCS"."dbo"."OrganizationUnit" "OrganizationUnit_1" ON "OrganizationUnitGroup"."OrganizationUnitID"="OrganizationUnit_1"."OrganizationUnitID") LEFT OUTER JOIN "DCS"."dbo"."Client" "Client_1" ON "OrganizationUnit_1"."OrganizationUnitID"="Client_1"."OrganizationUnitID"
WHERE ("Appointment"."StartDate"<{ts '2017-07-19 00:00:00'} AND "Appointment"."EndDate">={ts '2017-07-19 00:00:01'} OR "Appointment"."StartDate">={ts '2017-07-19 00:00:00'} OR ("Appointment"."StartDate">={ts '2017-07-19 00:00:00'} AND "Appointment"."StartDate"<{ts '2017-07-20 00:00:00'}) OR "Appointment"."StartDate"<{ts '2017-07-19 00:00:01'}) AND "Appointment"."Deleted"=0
|
|
|
|
bitte hör mal mit deiner komischen musik auf, danke lukasQuote:
[Only registered and activated users can see links. Click Here To Register...]
Wieso kannte ich diese epicness nicht?