Search - Joel Lipman .Com

1. Copy a table with structure and data into a temporary table: / Transact-SQL /; Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the ...; Created on 03 August 2012
2. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... photo, dull, simple, clean, modern::-2 abstract: ::5 Abstract Acrylic Painting::4 expressive brushstrokes, vibrant colors, abstract form, movement, non-representational, modern, contemporary, ...; Created on 11 February 2023
3. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... to another, sometimes you need to manage existing multi-lookups/users in a record. How? So the key point to remember is that all multi-select lookup and multi-user lookup fields are held in temporary ...; Created on 28 April 2021
4. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... credentials that Google Chrome cannot process. Network errors and attacks are usually temporary, so this page will probably work later.” My workaround was simply not to use Google Chrome but to ...; Created on 24 October 2020
5. COVID-19: Working from Home: / Articles /; ... was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my ...; Created on 05 July 2020
6. Warning: Save failed. Another menu item has the same alias: / Joomla /; ... caused the warning but give it a temporary alias (eg. for "about" give it the alias "about_new") Login to your database and browse to the #__menu table Search for any values in the `alias` column that ...; Created on 13 March 2015
7. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... listed building. Dynamic Zones are created using data fed for extreme weather conditions, earthquakes (by earthquake.usgs.gov) and at some point temporary flight restrictions. Currently Listed Zones: ...; Created on 24 October 2014
8. Search a database for a value and count matching rows: / Databases /; ... WHERE COLUMN_NAME = @p_Column ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME; -- Create temporary table to hold results CREATE ...; Created on 05 November 2012
9. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... -- Create temporary table to hold results CREATE TABLE #ListDistinctValuesAndCounts (myValue varchar(max), myColumn varchar(max), myCount int); -- Iterate through ...; Created on 26 October 2012
10. Prefix Line Numbers in a Text File: / MS-DOS /; ... c:\results_file.txt to %TEMP%\results_file.txt to send the file to your temporary directory instead of using the root c drive. If you do not have c:\windows folder than find where "cmd.exe" exists and ...; Created on 18 July 2012
11. Getting the mysql where in delimited string to work: / MySQL /; ... the loop DECLARE str_len INT; -- string length,self explanatory DECLARE out_str text DEFAULT ''; -- return string holder DECLARE temp_str text DEFAULT ''; -- temporary string holder DECLARE ...; Created on 02 January 2012
12. Joes FREE Website Thumbnailer (JWT): / Product Documentation /; ... into the format with the quality/size that is set in the program options. Consider this file temporary and if you want to delete/rename this and the images folder, the program will just create anothe ...; Created on 28 June 2011
13. List all cron jobs for all users: / Linux /; ... for cron_job_file in "$"/* ; do # */ [[ -f "$" ]] && echo "$ $" done fi fi done; } # Temporary file for crontab lines. temp=$(mktemp) ...; Created on 04 May 2011
14. Inserting incremental weeks in MySQL: / MySQL /; Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...; Created on 15 April 2011
15. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... MySQL where you can do iteration within the query (SELECT @ncount:=@ncount+1), we're stuck with T-SQL. Ask Google how to iterate in T-SQL and you're confined to functions, temporary tables or little subroutines ...; Created on 29 March 2011
16. URL passed settings in Reporting Services: / SQL Server Reporting Services /; ... will render fine in a webbrowser but when exported to PDF format, it will retain the previously deployed report settings (header&footer). Resolved this by clearing my web-browser's temporary files. Do ...; Created on 11 February 2011
17. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... functions, stored procedures, temporary tables, etc. This allows broader compatibility and customers who do not have DBAs to run this themselves. Personally I grant the user who will be executing the ...; Created on 30 January 2011
18. Making a CD copy with only one drive: / Windows OS /; ... click CANCEL On the desktop, double-click on MY COMPUTER Right-click on the CD drive and select OPEN Go to EDIT > SELECT ALL > EDIT > COPY PASTE to a temporary folder Select ...; Created on 23 September 2009
19. Using a HTML form and PHP to upload a file: / Personal Home Page /; ... or this feature just isn't available to you. Note: The temporary file gets deleted when the script finishes. So the file shouldn't exist if you check after the script has completed. Do the following ...; Created on 17 September 2009
20. Forum Rules: / Static Items /; ... Muting - This is where you are not able to talk on the board. You may still view it. Temporary Ban - This is where you are not able to view the board for a certain period of time. Permanent ...; Created on 31 May 2009