Generate a Timesheet in MySQL http://mail.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and...

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

SSRS: Performance Improvements: SELECT TOPhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 We're obviously not interested in shaving off time from 0.4 seconds; no, we're more interested in the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in the real world. Where do the extra 9 minutes come from? Not the SQL as this...

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

AHK Countdown Tooltiphttp://mail.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 to: Microsoft Windows 7 Enterprise AutoHotkey (see code for AHK version) What? Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better and have it calculate to the nearest second. I call this latest app...

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

Batch Process to rename multiple files using Windows DOShttp://mail.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and...

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

SITS: Export field code and namehttp://mail.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 to: Microsoft Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment....

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Android: Keytool and Google Maps displaying greyhttp://mail.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 To: Microsoft Windows 7 Pro Android Studio v0.8.6 beta Java Development Kit v1.8.0_20 What? The article below serves as a checklist to ensure I don't release an app that only displays maps to myself (again). Why? This took me a while to figure out so...

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

Android: Function to let user take photo or choose existinghttp://mail.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 a way to go. I haven't tested yet as I need a tablet/phone that doesn't have a camera... Applies to: Android Studio v0.8.9 Microsoft Windows 7 Pro Android: Min SDK v4.0.3 (IceCreamSandwich) API 15 Android: Target SDK v4.4 (KitKat) API 19

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 as a parameter with a value in it? Don't. The full code example above will work. Currently this only appears to accept Microsoft Word Documents and Adobe PDF files! Applicable to Zoho Books. If the user attaches text files (TXT) these will only attach...

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

ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 files and will collapse any subfolders as well as rename the files to unique filenames. ; ; Language: English ; Platform: Microsoft Windows 11 ; Author: Joel Lipman ; Version: 1.0 ; Description: This program will generate a clean Attachments.zip and its...

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

SSRS Templates in BIDS 2008http://mail.joellipman.com/articles/microsoft/ssrs/ssrs-templates-in-bids-2008.html

01 April 2011 and leave elements for all reports. File > Save selected item as... For SSRS 2008: Save in the folder: "C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject" Done!

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

Increase Recent Documents Number in Windows XPhttp://mail.joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

28 July 2011 what it's doing. I'm putting a note here just for me: Start > Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New DWORD Value Name it "MaxRecentDocs" Double-click on the new DWORD Set...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttp://mail.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 is just the best Unfortunately I make a living using Microsoft and Oracle products. I shouldn't say unfortunately as I don't see myself doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article...

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

UNC Paths in Sharepoint 2007 linkshttp://mail.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg....

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

List last modified files using FTP Command-linehttp://mail.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't have a clue. Here's what I've got so far: Open a command-prompt (Start > Run > Type COMMAND > OK)...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Modifying columns in a tablehttp://mail.joellipman.com/articles/database/modifying-columns-in-a-table.html

24 July 2013 MODIFY COLUMN misplacedColumn AFTER otherColumn; MySQL and Oracle PL/SQL ALTER TABLE myTable MODIFY myColumn myDataType Microsoft Transact SQL (T-SQL) ALTER TABLE myTable ALTER COLUMN myColumn myDataType

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

Regular Expressions in SQLhttp://mail.joellipman.com/articles/database/regular-expressions-in-sql.html

09 January 2014 '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0 -- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x') Microsoft T-SQL Note the circumflex/hat to negate the expression in the first example, and then the use of NOT LIKE in the second...

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

VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 code to the file: Set wshShell = CreateObject("Wscript.Shell") MsgBox ConvertToKey(WshShell.RegRead("HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\DigitalProductId")) Function ConvertToKey(Key) Const KeyOffset = 52 i = 28 Chars =...

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

Zoho Deluge: Generate and Send a CSV via Emailhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 each value with double-quotes because the values might have commas and someone may want to open this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event...

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