Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.04 » View Incident Report |
Serious |
Reported By: Uli Becker Reported On: 8/29/2010 For: Version 2.04 Build 1 |
CREATE VIEW "Wartezimmer" AS select status, FormatPatientSimple( p.name,p.vorname) as Patient, p.gebdat, s.Privat, DatumLast, DatumWartezimmer, FormatUhrzeit(DatumWartezimmer) as Uhrzeit, FormatWartezeit(DatumWartezimmer) as Wartezeit, Gruppe, s.PatientenID, ScheineID, if (datumlast >= datumwartezimmer then true else false) as LeistungenOK from scheine s join informa.patienten p on s.patientenid = p.patientenID where wartezimmer = true order by DatumWartezimmer,Patient DESCRIPTION 'Zeigt alle Patienten im Wartezimmer an'
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |