Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; What? I think I have a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template ...; Created on 06 August 2024
2. T-SQL: Parse an XML value: / Transact-SQL /; What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...; Created on 27 March 2014
3. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference ...; Created on 07 March 2014
4. Trim in T-SQL and SSIS: / SQL Server Integration Services /; ... equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE ...; Created on 14 May 2013
5. Convert a delimited string to table: / Databases /; What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...; Created on 26 October 2012
6. Inline Labels in Form Fields using Javascript: / JavaScript /; ... giving it the label value to indicate to the user to enter their Name (as in forename or surname). onFocus() - What to do when the user moves their cursor into the field or clicks on it. In this specific ...; Created on 21 August 2012
7. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...; Created on 01 August 2012
8. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... student_accounts WHERE student_accounts.studentUsername = trim(:p_myinparameter); SELECT NVL(student_details.studentFirstname, 'John') "FORENAMES", ...; Created on 24 January 2012
9. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... INITCAP(b.p_title) || ' ' || INITCAP(b.p_forenames) || ' ' || UPPER(b.p_surname) || ' (' || INITCAP(To_char(b.p_dob, 'DD-MON-YYYY')) || ')' "p_STUDENT_DETAILS", ...; Created on 19 January 2012