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

  1. Parameters not being used in report processinghttps://www.joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    was ignoring this completely Hardcoding the scalar local variables worked I have two parameters that will be submitted (GivenDate and GivenCampus). Consider the following script: --...

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

  2. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    will be quicker next time now that I noted it all down. The SQL Script: DECLARE @StartTime datetime, @EndTime datetime, @GivenDate datetime; SET DATEFORMAT dmy; SET @GivenDate = '23/03/2011'; --First slot of the day SET @StartTime = @GivenDate + '...

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

  3. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    opposite, where the week starts on the previous Saturday and ends on the last working day of the week. The Solution Where "givenDate" is the given date you have to calculate the last working day of: -- SAMPLE DATES ARE: -- -- 2012-04-27 10:00:00 -- is a...

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

  4. 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

    down to the desired name. Our advanced users are exceptions to the rule. Problem Consider the following query: SELECT rb.[GivenDate] , rb.[DateStart] , rb.[DateFinish] , rb.[ContactUsername] , rb.[ContactName] , rb.[Room] , rb.[BookingNotes] FROM...

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

  5. Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

    // // initialize list to hold valid appointment dates l_AppointmentDates = List(); // // initialize Start Date v_GivenDate = '2022-07-21'; // // setup list to loop through (= number of days) l_NumberOfDays = {1,2,3,4,5,6,7}; // // start with first date...

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

  6. Zoho Deluge - Get English Ordinalhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-english-ordinal.html

    methods are inconsistent as it depends on the date format of the system. Instead (update 2021), I now use the following: v_GivenDate = '2021-09-21'; m_Ordinals = {1:"st",21:"st",31:"st",2:"nd",22:"nd",3:"rd",23:"rd"}; v_Ordinal =...

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

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

    are in the given month (where "Gainsboro" is a type of light grey): =IIf(Month(First(Fields!Date.Value))=Month(Parameters!GivenDate.Value), "Black", "Gainsboro") Right-click on the Date textbox and select Font then for color, select Expression (fx):...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
Results 1 - 7 of 7