Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 for this was to copy the recurring event to the SharePoint calendar, then from within SharePoint to open the event and specify the recurrence rate. Sharing is Caring Now my colleagues have set up the calendar in their instances of Outlook, they can also...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 either of that numbered version or of any later version published by the Free Software Foundation. If the Program does not specify a version number of the GNU General Public License, you may choose any version ever published by the Free Software...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Three boxes, two roll over, one falls outhttps://joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 How? You could do loads of code hacks which is what I tested but all for nothing because you always end up needing to specify a third of the width. Our template was 900 pixels in width. I tracked down some code that was simply calculating with 33% as...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Restore MSSQL Error: Database is in usehttps://joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 close all other connections, click Yes. Restoring in SSMS, Right-click on the database Select Tasks > Restore... > Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish...

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

Parse a HTML Table into a ListViewhttps://joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 start of the extract (1a), a second string (1b) to refine the starting position of the extract, and a third string (2a) to specify the closing position of the extract. NeedleMarker is the offset and means when this function is used for several tables,...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 append the next letter in UPPERCASE and then append the remainder. // NOTE: This will work with "MacDonalds" as well (specify "Mac") but bear in mind "Mack" exceptionArray_this = new string[] { "Mc", "O'", "D'", "I'" }; foreach (string myValue in...

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

T-SQL: Parse an XML valuehttps://joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 returns typed XML SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER') FROM [dbo].[XML_EVENTS] -- value() returns single value, specify data type as second parameter SELECT Event_XML.value('(/STAFF/EMPLOYEE_NUMBER/@name)[1]','varchar(20)') FROM...

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

Convert to Proper Case in T-SQLhttps://joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 BEGIN -- declare some variables DECLARE @Reset BIT; DECLARE @Ret VARCHAR(8000); DECLARE @i INT; DECLARE @c VARCHAR(2); -- specify reset SELECT @Reset = 1, @i=1, @Ret = ''; IF (UPPER(@Text)=@Text Collate Latin1_General_CS_AI) BEGIN -- cycle through each...

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 [0.1] Map: location search - [0.1] Map: tap twice to zoom in - [0.1] Map: wind and weather data v??? In Development: - Map: specify weather forecasts for a day - Map: current location response issues - Map: screenshot for offline use - Map: enable news...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 $api_url); // where to send the variables to curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml')); // specify content type of what we're sending curl_setopt($ch, CURLOPT_HEADER, 0); // hide header info !!SECURITY WARNING!!...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 the Admin ID to a number that hasn't been taken yet or to use the current one and is specified as a local variable. -- Specify v2.5.x admin ID and v3.4.x admin ID SET @v25_admin_id=42; -- Set this to the ID number of the user in your Joomla 2.5.x SET...

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

Import Excel CSV file as JavaScript arrayhttps://joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 URL from the HTML file launching this function (not from the if external JS)) // add parameters to this function to specify rows based on a criteria var my_array = populate_array_from_csv(this_file_url); // eg. var my_array =...

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

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 before the current date, then set it to the last Tuesday of next month. Why? This was a request by a client who instead of specifying the 1st of every month, or 15th of each month, to say the first Monday of the month (ignoring bank holidays) or to say...

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

AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to A_ScriptDir) to specify what folder to scan for files. The 3rd button simply reloads the app (used mostly for testing/development). Lastly, a...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 form f_MyImages = MyImages[Name == "Logo"]; v_Filename = f_MyImages.MyImage.getSuffix("/image/").getPrefix("\""); // specify publish key of published report (not the form) v_PublishKey =...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 the ampersand (except for MySQL which doesn't need to and in my opinion is the best SQL). Additional Note(s): select can specify up to 50 fields. Defaults to 200 but can return up to 10000 records (NB: use endpoint https://www.zohoapis.com/crm/v7/coql)....

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 Here I have 1 page and 1 article documenting the process. How? I'm breaking this down into 3 stages: Zoho Creator: Specify Custom Domain Domain Registrar: Setup subdomain and add CNAME Zoho Support: Get Zoho to setup SSL 1. Setup Custom Domain So go...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 I will leave this on "Default") and set the return type (again in this example, I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our example I am going to prefix it with "l_" (for list) and the plural of what kind...

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

Zoho CRM: Standard Setup for Tax Rateshttps://joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 over the "Products" module and then over the ellipsis Click on "Customize Tax Rates" For our clients in the UK, we tend to specify the tax rates as "Standard Tax" @ 20% and a "Zero Vat" @ 0% Click on "Save" and you've pretty much specified the tax rates...

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