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 simple is required, the following 29 results were found.

  1. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    obvious to some but then you google the above and you get half a million results. That's a lot of reading so here's the simple fix for my issue: Returning an error: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + rm.[Capacity] + ', ' + rm.[Type] + ', '...

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

  2. T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    with zeros) How? So how do we do it? In the above example, Joel Lipman has two qualification records. So let's start with a simple query: SELECT RIGHT('000' + CAST(e.ID AS VARCHAR), 3) AS EmployeeNo, RIGHT('000' + CAST(q.Employee AS VARCHAR), 3) + '01'...

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

  3. Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-stored-procedure-structure.html

    version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle stored procedure as my MySQL and T-SQL stored procedures work slightly differently and are easier to...

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

  4. Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/cms/website-development/developers-checklist-taking-over-a-project.html

    (if Windows) errors.log (if Linux) Above and beyond Product Handover (branded pack with contact details - make it simple and friendly!!!) Warranty / Grace Period (agreed support period post production - fees and estimates) Behind the scenes (code...

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

  5. PHP & MySQL Search Enginehttps://www.joellipman.com/articles/cms/website-development/php/php-a-mysql-search-engine.html

    of cramming information endlessly in cyberspace. So we want to give a search engine to our users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE...

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

  6. Sun-Dried Tomato Basil Couscous Recipehttps://www.joellipman.com/component/content/article/sun-dried-tomato-basil-couscous-recipe.html?catid=96&Itemid=165

    I've recently been making couscous a lot and this is the simplest recipe I use on the net. Simple and quick couscous is flavored with sun-dried tomatoes, green onions, and basil. This dish may be served hot or at room temperature. Use store-bought...

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

  7. Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/else/fintech/xero/xero-send-multiple-invoices.html

    solution: Send all Zoho invoices in API call to Xero... apparently it can accept up to 60 invoices in one call. How? Crazy simple solution, your JSON needs to have the key "Invoices" and the list of invoices to create: {"Invoices":[... list of invoices...

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

  8. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a dropdown appears with all available values listed. The Problem The values are listed...

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

  9. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    to format the report after they've already gone through the hassle of clicking on the big fat refresh button... Keeping It Simple Silly. So the suggestion of selecting all cells and then right-clicking and selecting "row height" is beyond us. We have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 21 - 29 of 29