SELECT MAX(logNo) AS logNoDefault FROM SRTable1 INSERT INTO SRTable1 (logNo, requestDate, srlog, srlogNo, JO1, JO2, JO3, PY, requesterFName, requesterLName, requesterOrgCode, requesterEmail, requesterPhone, requesterMS, requesterBldg, requesterRm, serviceBldg, serviceRm, serviceType, serviceDescription, reqCompleteDate, workingPOCFName, workingPOCLName, workingPOCPhone, approverFName, approverLName, approverEmail, Approve) VALUES ((CONVERT(numeric(10), #logNoNew#)), '#requestDate#', '#srlog#', '#srlogNo#', '#JO1#', '#JO2#', '#JO3#', '#PY#', '#requesterFName#', '#requesterLName#', '#requesterOrgCode#', '#requesterEmail#', '#requesterPhone#', '#requesterMS#', '#requesterBldg#', '#requesterRm#', '#serviceBldg#', '#serviceRm#', '#serviceType#', '#serviceDescription#', '#reqCompleteDate#', '#workingPOCFName#', '#workingPOCLName#', '#workingPOCPhone#', '#approverFName#', '#approverLName#', '#approverEmail#', "0") Acknowledgement

Request for Plant Engineering Services

You have successfully submitted the following Service Request

Log Number: #logNoNew#
SR Number: #srlog##srlogNo#
Request Date: #requestDate#
Job Order No: #JO1# #JO2# #JO3#
Program Year: #PY#
Requester: #requesterFName# #requesterLName#
Org Code: #requesterOrgCode#
Email: #requesterEmail#
Phone: #requesterPhone#
Delivery Point/Mail Stop: #requesterMS#
Building: #requesterBldg# - Room: #requesterRm#
Service Requested:
Bldg: #serviceBldg# - Rm: #serviceRm#
Type of Service: #serviceType#
Description of Service: #serviceDescription#
POC when work starts: #workingPOCFName# #workingPOCLName#
Phone: #workingPOCPhone#
Approving Official: #approverFName# #approverLName#
Approving Official´s Email: #approverEmail#

Thank you!

Return to Main Menu

Date: #requestDate# The following was submitted by #requesterFName# #requesterLName# Log Number: #logNoNew# Org Code: #requesterOrgCode# Email: #requesterEmail# Phone: #requesterPhone# Delivery Point/Mail Stop: #requesterMS# Building: #requesterBldg# Room: #requesterRm# ------------------------------------------------ Service Requested: Bldg: #serviceBldg# - Rm: #serviceRm# Type of Service: #serviceType# Description of Service: #serviceDescription# POC when work starts: #workingPOCFName# #workingPOCLName# Phone: #workingPOCPhone#
------------------------------------------------ To APPROVE or DISAPPROVE this Service Request, go to http://code.arc.nasa.gov/jf/jfp/srsrch6.cfm and enter this SR number (#srlog##srlogNo#) or the requester's name (#requesterFName# #requesterLName#) or Log Number (#logNoNew#). Thanks for using the JFP Service Request! JFP SR Manager