T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 turn on my computer" and me replying "why would you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Reminder on SSRS row separatorhttps://joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 09:00 17:00 Notes Tuesday 04/10/2011 Another Office 09:00 17:00 Notes Row Seperator This follows on from my T-SQL Record Separator article. If you are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to use the...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 run twice more often then another, then is it slower? Not necessarily. Like all measures in bytes, I would like a thousand separator, and lose the decimal ".00". I need the size of the report but the value has to be returned as part of the aggregate...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const VK_NUMPAD7 = $67 Const VK_NUMPAD8 = $68 Const VK_NUMPAD9 = $69 Const VK_MULTIPLY = $6A Const VK_ADD = $6B Const VK_SEPARATOR = $6C Const VK_SUBTRACT = $6D Const VK_DECIMAL = $6E Const VK_DIVIDE = $6F Const VK_ATTN = $F6 Const VK_CRSEL = $F7 Const...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 of Excel 2007 PivotTables Aesthetics: Drilldown bolded items are NOT the sum of a expanded node. (despite no line separator or the totalled value in the corresponding row) Show this week date range by default Use a WHERE clause:...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Connect to Joomla database in standalone scripthttps://joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 this out or observe errors to see which directory you should be in (this is two subfolders in) define( 'DS', DIRECTORY_SEPARATOR ); require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' ); require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php'...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 : (DT_NUMERIC,12,4)TRIM(ContributionValue) -- it's a number (DT_NUMERIC,12,4)TRIM(ContributionValue) -- a thousandth separator in the data (eg. 2,534.0000)? ISNULL(ContributionValue) || (LTRIM(ContributionValue) == "") ? "0.0000" :...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions3.1.1 Artur- Enhancement: Added parameter: Weblink separator height. - Enhancement: Added parameter: Display submitted by. - Enhancement: Added parameter: Display category. - Enhancement: Reorganized parameters "Module...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Zoho Deluge - Some Useful Regular Expressionshttps://joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 = v_MyString.replaceAll("\b(Posh)([^ ]*)","$1 and $2",false); // yields Posh and David Beckham UK/US Decimal Separator and Commas: v_MyString = 1234.567; v_FormattedString = (v_MyString.round(2)).toString().replaceAll(("(?Link"; v_FormattedString =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 = (v_QuoteTotal.toDecimal() / v_ExchangeRate).toDecimal().round(2); // // format currency with commas (thousand separator) and 2 decimals v_QuoteTotalStr = v_QuoteTotal.toDecimal().round(2).toString().replaceAll("(?" + v_QuoteRef + ""; // don't forget...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 like in the following example (note I have applied a regex to use US/UK numbering format with 2 decimals and thousandth separator, eg. 1,000.00): l_TemplateQuotedItems = List(); v_Index = 1; if(!isnull(r_LineItems.get("data"))) { l_LineItems =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Format Numbers in AutoHotkey with Commashttps://joellipman.com/articles/automation/autohotkey/format-numbers-in-autohotkey-with-commas.html

20 September 2011 a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB