Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming there is required, the following 217 results were found.

  1. SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

    below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When you ok this you should be on the following screen: Select the Report Type: For this calendar we want matrix because...

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

  2. Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/else/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

    were off sick. When migrating to a new system, the destination wanted 1 row per day. This meant that if in the old system, there was 1 row with an employee who took 2 days off, we would want 2 rows for that date for the same employee in the new system....

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

  3. Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

    This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to...

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

  4. Webdeveloper-Speakhttps://joellipman.com/articles/cms/website-development/webdeveloper-speak.html

    website design, development and usability evaluation services." Their website has initiated a Web Definition Glossary (there are others but this one's got that "kiwi" approach) A few terms I wanted to list up: "above the fold" or "before-the-scroll" The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  5. 301 Redirect using htaccess filehttps://joellipman.com/articles/cms/website-development/301-redirect-using-htaccess-file.html

    There are a lot of articles & posts out there that cover the same topic, but as this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  6. Pure JS - Display Time Elapsed & Remaininghttps://joellipman.com/articles/cms/website-development/js/pure-js-display-time-elapsed-remaining.html

    example of Javascript code to update and display the elapsed/remaining hours minutes and seconds in real-time. Why? I know there are a lot of articles out there that write about the same, but this is an example that I was coding and found to be one of...

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

  7. Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    $my_description = htmlspecialchars($my_description); Did I miss anything? So none of the above worked. If there is another solution out there, I didn't find one that worked otherwise I'd have included it in this article. How? The fix is a PHP one and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  8. Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/cms/website-development/php/convert-past-date-to-time-ago-in-php.html

    just over but less than 4 days ago 1 week ago // where event is just over 1 week ago but less than 2 weeks ago How? I know there are so many examples out there that do this perhaps better but this one I understand and can customize to fit my needs. This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  9. GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/component/content/article/godaddy-apache-cpanel-install-ssl-certificate.html?catid=111&Itemid=165

    certificate seems to require re-installing each year despite it's expiry in a couple years time. The first time I did it, there were more steps; the second time I just did as per the below. If I ever have to do the long process again, I'll add it to...

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

  10. DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://joellipman.com/component/content/article/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html?catid=113&Itemid=165

    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'd recommend anyone who doesn't have a photographic...

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

  11. DJI Phantom FC40 - Fun at the raceshttps://joellipman.com/component/content/article/dji-phantom-fc40-fun-at-the-races.html?catid=113&Itemid=165

    treat it like a First-Person-Shooter game where I strafe right moving forwards in an arc to go round corners. Then I learnt there were so many different angles and routes I could have taken (NTS: Take picture of whole track beforehand and plan a route)....

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

  12. Newbies guide to be the local computer guyhttps://joellipman.com/component/content/article/newbies-guide-to-be-the-local-computer-guy.html?catid=116&Itemid=165

    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 their window or on their cash wrap. Initially, charge a nominal fee…maybe...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *

  13. Zoho Deluge - Pad with leading Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-pad-with-leading-zeros.html

    There may be other articles out there documenting this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing...

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

  14. Forgotten Super User Password in Joomla 2.5.x - 3.xhttps://joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

    (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text there Find the row of your forgotten user and Paste the text there. Test by logging in as the forgotten user Done

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

  15. SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/component/content/article/ssrs-use-t-sql-like-with-a-parameter.html?catid=75&Itemid=165

    must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and...

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

  16. SSRS No Delay for First Report of the Dayhttps://joellipman.com/component/content/article/ssrs-no-delay-for-first-report-of-the-day.html?catid=75&Itemid=165

    60 seconds to get with it and display the report. Any subsequent running of the report loaded it almost immediately. How? There are a few options out there but this one made a noticeable difference. Applicable to the server, it will affect all reports...

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

  17. SSRS Display question mark when date is blankhttps://joellipman.com/component/content/article/ssrs-display-question-mark-when-date-is-blank.html?catid=75&Itemid=165

    I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if there is no date to populate the field. Why? At the moment, the expression in there is something like this:...

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

  18. Search and Replace in a MySQL Databasehttps://joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration Tool (like Navicat or SQLYog), and still there at night editing each field so...

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

  19. Strip HTML in MySQLhttps://joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html

    From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the query. The function that did work...

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

  20. Typographyhttps://joellipman.com/articles/else/e-commerce/woocommerce/typography.html

    illustrate how dreams can guide us. Blockquotes Even the all-powerful Pointing from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A...

    • Type: Article
    • Category: Uncategorised
    • Language: *
Results 61 - 80 of 217