#cookie.Testdate# select Patient_ID,concat(First_Name_M0040,' ',Last_Name_M0040) as patientname from #Request.prefix_db_agency#.patient where First_Name_M0040="john" limit 0,10 select Agency_ID,Employee_ID,Record_creation_Date,concat(Last_Name,' ',First_Name) as employeename from #Request.prefix_db_lookup#.Employee where First_Name="charles" limit 0,10 select distinct Record_creation_Date from #Request.prefix_db_lookup#.Employee limit 0,10
  • #date#
    • #getpatientid.Last_Name#
    #closedate#
    • #getclosematch.Last_Name#