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

  1. Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/component/content/article/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html?catid=110&Itemid=165

    1: Fields in the same column are not aligned with guidelines or snap-togrid To prevent fields from appearing in different rows, horizontally align fields with guidelines: In Design view, click the vertical ruler to create a vertical guideline. Click one...

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

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

    rb WHERE rb.[GivenDate] BETWEEN @GivenDate AND @ToDate AND rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's the parameter that's the issue. You don't enclose it with...

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

  3. MySQL Oracle equivalentshttps://www.joellipman.com/articles/else/database/mysql-oracle-equivalents.html

    MySQL Oracle - See if a table exists SHOW TABLES Select table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM table1 WHERE ROWNUM

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

  4. SQL: Use CASE for Relevance columnhttps://www.joellipman.com/articles/else/database/mysql/sql-use-case-for-relevance-column.html

    to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find relevant terms to...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 61 - 64 of 64