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

  1. SSRS Querying on either of 2 Parametershttps://www.joellipman.com/component/content/article/ssrs-querying-on-either-of-2-parameters.html?catid=75&Itemid=165

    (enquired/applied only). So following the above, I end up with: Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when the report is executed. So my first dataset has to include the Username check as well (…WHERE...

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

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

    variables SET @myCounter = 0; SET @minStrLen = LEN(@p_SearchString) - 1; SET @maxStrLen = LEN(@p_SearchString) + 1; -- Populate Cursor1 (used to generate final SQL query to run) DECLARE Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE...

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

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

    BEGIN -- Declare some variables to use DECLARE @SqlToExecute varchar(max), @TableToProcess varchar(max); -- Populate Cursor1 (Used to hold valid table names) DECLARE Cursor1 CURSOR FOR SELECT TABLE_CATALOG + '.' + TABLE_SCHEMA + '.' + TABLE_NAME FROM...

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

  4. Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    WHERE TABLE_NAME = @TableName AND ORDINAL_POSITION = 1 ); -- Generate Select Query to extract data from given table and populate temporary table SET @SqlToExecute='SELECT ROW_NUMBER() OVER(ORDER BY ' + @ColName + ') AS dummyIndex, ' + STUFF( ( -- Code...

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

  5. Zoho Deluge - Get Full Day Namehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-full-day-name.html

    and this is working: My_Date = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // lists Day_Names =...

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

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

    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: =Format(Fields!MyCompletionTime.Value,...

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

  7. MySQL Updating a database table from another tablehttps://www.joellipman.com/articles/else/database/mysql/mysql-updating-a-database-table-from-another-table.html

    A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
Results 21 - 27 of 27