Search - Joel Lipman .Com

1. Zoho Deluge - Get English Ordinal: / Zoho /; What? This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November ...; Created on 08 November 2018
2. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... 01-Nov-21 // Tuesday 02-Nov-21 Note that Sunday is day 1 of the week. Saturday is day 7 of the week. Here's the English ordinal bit I used: m_Ordinals = ; v_Day3_Ordinal = ifnull(m_Ordinals.get(v_NextDay.toString("d").toLong()),"th"); ...; Created on 02 November 2021
3. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... ¡ Upside-down Exclamation 0161 ¿ Upside-down Question 0191 ª Feminine Ordinal 0170 º Masculine Ordinal 0186 « Left angle quote 0171 » Right angle quote 0187 Additional "Alt Codes" can ...; Created on 03 June 2021
4. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... AS VARCHAR(10)) + ')' END FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName ORDER BY ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ';'; EXEC(@TableDeclaration); -- ...; Created on 03 August 2012
5. 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
6. Alternative method of displaying Unicode in Autohotkey GUI: / AutoHotkey /; ... ordinal indicator 167 A7 U+00BA º masculine ordinal indicator 168 A8 U+00BF ¿ inverted question mark 169 A9 U+2310 ⌐ reversed not sign 170 AA U+00AC ¬ not sign 171 AB U+00BD ½ vulgar fraction one ...; Created on 29 September 2011
7. Formatting a date in an MDX query: / Transact-SQL /; ... English Ordinal Suffix in T-SQL for MDX Working in the UK my bosses like the English Ordinal Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query ...; Created on 11 January 2011