Search - Joel Lipman .Com

1. Zoho Deluge: Proper Case for Names: / Zoho /; ... join all together v_FullName = trim(v_FirstName + " " + v_LastName); info v_FullName; // // yields: Billie-Jo McDonald-O'Leary II of Cambridge-Worcester-Oxford Caveat(s): This solution does not ...; Created on 13 July 2023
2. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... missing associated purchase orders altogether. I had to break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine the cost ...; Created on 03 November 2022
3. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... up to 2, right through 3 to 1, then down to 5... Now it all blends together: Error(s) Encountered: DisplayPort to DVI cable doesn't work: I get what I pay for I guess... I went for a slightly more expensive ...; Created on 12 March 2022
4. Excel - Check a column for values found in another column: / Excel /; ... is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( ...; Created on 14 February 2019
5. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgrade: / Quadcopters /; I decided to repair the hull integrity of my DJI Phantom FC40 after a crash and sorta had the day off so... There are so many pictures because I wanted to be sure I could put it back together again, I' ...; Created on 04 September 2014
6. Hide a Drive per User in Windows 7: / Windows OS /; ... drive option hex or decimal number from the list below you want to set as restricted, and click on OK. -- Restrict multiple drives by adding the values together -- For Example: To Restrict B & C, enter ...; Created on 28 March 2014
7. T-SQL Conversion failed when converting the varchar to data type int: / Transact-SQL /; ... silly T-SQL concatenation which requires plus signs and thinks it's super clever when it tries to add a number and a string together; then remembers it's a Microsoft by-product and realises it can't. Solved ...; Created on 14 May 2013
8. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... 24 minutes (our working day). // 4 days times 7:30 and 1 day of 7:00 will result in 37:00 total. // Our working week starts on Monday 00:00 and ends on Sunday 23:59. Putting it together Your ...; Created on 27 April 2012
9. Excel PivotTable Filter List Ordering: / Excel /; ... the dropdown. (NOTE the "More Options" button) Click on OK to sort the values Note:Office 2010: If items did not sort, then remove the column from the PivotTable altogether, hit the Data Refresh button ...; Created on 05 September 2011
10. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... the parameters and it will work. Set MySQL parameters (using @ - same as T-SQL) and Microsoft Excel 2007 gets confused. Putting it all together Create a SQL query that will return: staffname, ...; Created on 24 August 2011
11. Newbies guide to be the local computer guy: / IT Support /; Get business cards made. Pass them out where ever you go. Don’t rent a storefront yet. Go to people’s businesses/homes and do the repairs there. Ask local businesses if you can post a flyer in ...; Created on 28 April 2011
12. Keyboard and mouse shortcuts in Google Chrome: / Google /; ... Press Backspace, or Alt and the left arrow together. Goes to the previous page in your browsing history for the tab. Press Shift+Backspace, or Alt and ...; Created on 23 September 2009
13. Cranberry flapjack: / Hobbies /; ... oz double cream 1 orange, peeled and segmented Method 1. In a bowl mix together the oats, honey, self-raising flour, egg and dried cranberries. This should form a thick batter. 2. Melt the butter in ...; Created on 07 July 2009
14. Terms & Conditions: / Static Items /; ... terms and conditions of use, which together with our privacy policy govern Joel Lipman .Com's relationship with you in relation to this website. The term 'Joel Lipman .Com', 'I', 'myself', 'us' or 'we ...; Created on 30 May 2009
15. Tabs: Created on 17 April 2015
16. Slideshow Addon: Created on 30 November -0001
17. Image Layouts: Created on 30 November -0001