... ... this is the ID of the Leave form record.
p_Dept as the name of the "Department" ... this is found on the Employee form not the leave form.
p_LeaveFrom this is the value of "From" on the "Leave" form ...
... John Smith-Jones
HEAD OF IT SERVICES Head of IT Services
FLAT 123A Flat 123A
MRS. O'CONNOR-MCDONALD Mrs. O'Connor-McDonald
ORG_DEPT_STATUS Org_Dept_Status
SEND.HELP.NOW Send.Help.Now
PO BOX 1234 PO ...
... + ', ' + rm.[Zone] + ', ' + rm.[Capacity] + ', ' + rm.[Type] + ', ' + rm.[DeptId])) AS RoomDetails
// yields Conversion failed when converting the varchar value ', ' to data type int
My issue was ...
... AS 'Contact',
CHAR(10)+c.[Owner]+CHAR(10) AS 'Dept',
CASE
WHEN CHARINDEX('/', c.[Phone]) > 0 THEN REPLACE(REPLACE(c.[Phone], ' ', ''), '/', CHAR(10))
WHEN CHARINDEX(' or ', c.[Phone] ...
... (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example:
SELECT
Date,
Reservation,
Contact, ...
... tank - Study the basics from this; I will not be covering them.
- W3Schools - Many links listed below will take you to this website, which is an excellent resource for learning JavaScript in depth.Thank ...
... AS 'Booking Notes',
c.[Name] AS 'Contact',
c.[Company] AS 'Dept',
c.[Phone] AS 'Phone'
FROM [CMISdata].[cmisuser].[SLOTDETAILS] sd
INNER JOIN [CMISdata].[cmisuser].[TIMETABLE] tt
ON ...
... works 100% for me using the MetaMod tool without using any template hacks. The instructions on the metamod page are very vague so I wanted to make it bit more in-depth for this specific use. I'd love to ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.