Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 variable). So the idea here is to run the below example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE...

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

Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

31 May 2009 causes thread's to go off topic, and most importantly, it hurts the person being flamed. The victom may defend themselves against any accusations made to them, but may not make any additional accusations to the flamer (which also counts as flaming). No...

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

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 Done! The filter dropdown should retain the order. Alternatively Similar to the above, open a Microsoft product Bang "Head" against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the date returns in...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 has the real database names and all website content, so do not redistribute without taking security measures. Run the SQL against your new database Open your favorite database management tool (phpMyAdmin, workBench, navicat, sqlyog?) and connect to the...

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

MySQL: Find records in one table that are not in another.https://joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 are noticeably slow (as observed by the customer...) and then others not. The What I'm going to run these benchmark tests against a system that is both up and running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the like....

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 Additionally, the second solution will mean each dataset must at least join both tables that you are using the OR clause against. There must be a solution that executes a query at report execution time and populates/assigns the local variable ID...

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

Search a database for a value and count matching rowshttps://joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 @p_Value and @p_Column and using only the code ** ** from the BEGIN to the END (exclusive) - allows you to run ** ** this against any table only changing the parameter column. ** ** ** ** Usage: ** ** EXEC [usp_CountRecordsPerTablePerColumn] '3',...

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

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

03 April 2009 to the covered work, and you disclaim any intention to limit operation or modification of the work as a means of enforcing, against the work's users, your or third parties' legal rights to forbid circumvention of technological measures. 4. Conveying...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 Deluge) rather than the graphical user interface (GUI). Note this would probably be similar to when trying to enter a time against a project Task but this article is focused on getting this working against Project Issues. Also note, we will refer to...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 m_SearchCriteria.put("sort_order","A"); m_SearchCriteria.put("sort_by","payment_number"); // // fetch all payments against this customer in order of payment reference (oldest to most recent) r_SearchResults =...

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

Zoho Analytics: Set Up a Widget Displaying Sales Personhttps://joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the deals against a deal owner and needed to repeat this for all the invoices against a sales person. It adds to the effect on loading the...

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

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

03 November 2022 an invoice on behalf of the account manager (person who manages the customer's account), so let's get the account manager against the customer and if that isn't populated then the first estimate, sales order, invoice created by someone in relation to...

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for...

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

K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 be repaired The Quick Fix I managed to fix this with this SQL command . Note: you need to be able to run SQL commands against your database. My client had phpMyAdmin installed so I click on "jos_k2_items" table and then click on the "SQL" tab Type the...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 2011-03-23 08:00:00.000 Test2 Room 08:00:00 09:30:00 2 Note that [Test1 Room] will appear as a row but have no slots booked against it. [Test2 Room] will both appear as a row and have 3 slots taken up (if you left the above to 30 minute slots). Tweaks...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty abysmal and worse if...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 the database names to match your setup Change the table name prefixes to match your setup Run the modified SQL script against your database. Note: It is not advisable to run this on a production website! --...

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

Country Lookup by IP address CSVhttps://joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 and a PHP script. As well as a CSV file equivalent. How to use: Download from my site: «Download» Run the SQL script against a test database, Modify the table name to use if necessary. Uncomment the drop statement if running for the second time. Modify...

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

Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing the...

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

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 The below is just a draft agreement and has to be mutually agreed. As the client, feel free to adjust, suggest and query against this. Here is an outline agreement between joellipman.com and you: Once I have the domain names, I will configure my server...

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