pears.ShiftConsultants

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."ShiftConsultants" IS 
{CREATE FUNCTION ShiftConsultants 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN entby CHAR(20),IN entat TIMESTAMP,IN fillby CHAR(20),IN fillat TIMESTAMP)
RETURNS long VARCHAR
BEGIN
  DECLARE rv long VARCHAR;
  SET rv='';
  IF entby IS NOT NULL THEN
    SET rv=string('Entered by: ',(SELECT userid FROM staff WHERE staffid = entby),' ',dateformat(entat,'dd/mm/yyyy hh:nn'),'  ')
  END IF;
  IF fillby IS NOT NULL THEN
    SET rv=string(rv,'Filled by: ',(SELECT userid FROM staff WHERE staffid = fillby),' ',dateformat(fillat,'dd/mm/yyyy hh:nn'))
  END IF;
  RETURN rv
END
}