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

05 December 2013 work that day. EndTime will be the latest someone works that day. Time is recorded by tasks with an actual duration in seconds (eg. "Monday morning, I worked 45 minutes on setting up a Joomla 2.5.x demo site; I started at 9am and finished at 9:45.",...

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular report (which searches for results matching the submitted parameter) to run....

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 sharp-focus, high-quality, artistic, unique, award-winning photograph, Canon EOS 5D Mark IV DSLR, f/8, ISO 100, 1/250 second, close-up, natural light, professional, flattering, headshot::3 black and white, grainy, deformed, watermark::-2 photo: ::5...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 0,'height': v_win_height,'width': v_win_width }).chain(function(){ this.start.delay(1000, this, { // duration of 1 second for transition 'opacity': 1,'top': 0,'left': v_left_most,'height': v_win_height,'width': v_win_width }); }).chain(function(){...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 to tidy these all up would leave the data more and more unreliable. So Shopify want your webhooks to respond within 1 second. This is about enough time to store the record but that's it. Processing the record must be done at a later time or in a...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query. The stored procedure compiles successfully and...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 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 "byeBU" and this is version 0.4 Beta (unofficial app). Why? Something to do... How? The following...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 a INNER JOIN student_details b ON a.student_id = b.person_id WHERE a.student_id = p_STUDENT_REF; -- ending that second begin I had after my variable declaration END; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR (-20001, p_STUDENT_ADNAME || ':$:'...

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

Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 the snippets for the various DSTs around the world. US (Except Arizona, Hawaii and US Territories?): DST Start Starts Second Sunday in March at 2:00 DST End Ends First Sunday in November at 2:00 // // Starts Second Sunday in March at 2:00...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 (White) 1 £19.99 Build & Cost Breakdown Initial Build Total (functional PC, onboard GPU, 32Gb RAM, Previous O/S): £1,099.81 Second Part Build Total (GPU, RAM doubled, Windows 11 Pro, other): £959.84 Total: £2,059.65 Not Used Case Fans 2 fans from the...

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

Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 the other windows, much like the start menu/task bar (only this program is beneath the task bar). It's currently set to 15 seconds between each photo and it happily did my 153 (has done a few times over quite quickly due to testing). Options/Features...

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

Unix Date Format Specifiershttps://www.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 13 %p locale's upper case AM or PM (blank in many locales) PM %P locale's lower case am or pm pm Minutes %M MM minutes 20 Seconds %s seconds since 00:00:00 1970-01-01 UTC (Unix epoch) 1309785651 %S SS second 00–60 (The 60 is necessary to accommodate a...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 lines prefixed so that I can explain the code. What? Change contents of "original_file.txt" The first line of my code The second line of my code The third line of my code To "results_file.txt" 1: The first line of my code 2: The second line of my code...

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

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

14 March 2013 for text file where I needed two derived column tasks, the first checks if the Date was blank and puts a NULL string. The second takes this string and converts it to a date: -- Assuming EndDate is optional (can be null) and in format DDMMYYYY: --...

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

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

07 March 2014 Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 follows the manual (or the logic thereof as I don't use the client library) and is a function sending two requests, the second is the appropriate multipart function which uploads and names the file in a single request, and the third is a 'nice-to-have'...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 JSON key "name" and extract value. Hide the first column in the list view (contains "Profile 1", "Profile 2",...) Sort the second column (contains "Joes Personal Profile", "Joes Work Profile", etc) Create subroutine for when listview row is...

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

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 c_SubformRows = r_Record.mySubform1; } // set an else if condition else if(r_Record.Type == "Subform2") { // store the second subform into a collection c_SubformRows = r_Record.mySubform2; } // loop through the selected subform rows of this record for...

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

Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 as pseudo-subqueries. The first task was to determine the cost of each item purchased; including shipping and tax. The second is to associate these to the invoiced items and work out the profit. The third is to group by the sales person, date, and...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 case, this was due to the CRM being set to a different timezone (7 hours off) and for testing purposes, I need to add the second parameter of toString() to a desired timezone. The CRM format without a second parameter is...

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