pears.NetAgencyVacancyNotes

CREATE PROCEDURE "pears"."NetAgencyVacancyNotes"( IN "pWebUserID" CHAR(20),IN "pLineID" CHAR(21) ) 
RESULT( "pNotes" long VARCHAR ) 
BEGIN
  DECLARE "LineType" CHAR(1);
  DECLARE "LineID" CHAR(20);
  SET "LineType" = "left"("pLineID",1);
  SET "LineID" = "right"("pLineID",20);
  CASE "LineType"
  WHEN 'V' THEN
    SELECT top 1 "othernotes" FROM "vacancy" WHERE "vacancyid" = "LineID"
  WHEN 'P' THEN
    SELECT top 1 "clientnote" FROM "tempshiftplan" WHERE "tempshiftplanid" = "LineID"
  END CASE
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetAgencyVacancyNotes" IS 
{CREATE PROCEDURE pears."NetAgencyVacancyNotes"(IN pWebUserID CHAR(20), IN pLineID CHAR(21))
RESULT(pNotes long VARCHAR)
BEGIN
	DECLARE LineType CHAR(1);
    DECLARE LineID CHAR(20);
    SET LineType=LEFT(pLineID,1);
    SET LineID = RIGHT(pLineID,20);
    CASE LineType
        WHEN 'V' THEN 
            SELECT top 1 othernotes FROM vacancy WHERE vacancyid=LineID;
        WHEN 'P' THEN
            SELECT top 1 clientnote FROM tempshiftplan WHERE tempshiftplanid=LineID
    END CASE;
END
}