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

  1. Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

    DECLARE @GivenDate datetime, @GivenCampus varchar(100), @setId varchar(10), @weekNumber int, @siteId nvarchar(5), @baseDate datetime, @specifiedDate datetime, @specifiedCampus varchar(25) SET DATEFORMAT dmy --SET @GivenDate = '1/7/2011' --SET...

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

  2. Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

    sd.[SetId] = @setId AND dateadd(d, tt.[WeekDay] - 1, @baseDate) = @GivenDate AND wm.[WeekNumber] = @weekNumber AND tt.[SiteId] = @siteId AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%' --Cycle through all possible rooms and include these in the...

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

  3. SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

    Consider the following expression as the one we use to get the equipment information: SELECT DISTINCT re.[RoomId] ,re.[SiteId] ,re.[EquipId] ,eq.[Description] FROM [ROOMEQUIPMENT] re INNER JOIN [EQUIPMENT] eq ON eq.EquipId=re.EquipId WHERE...

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

  4. T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

    LEN(c.[Phone]) > 20 THEN REPLACE(REPLACE(c.[Phone], '01202 ', '01202'), ' ', CHAR(10)) ELSE c.[Phone] END AS 'Phone', tt.[SiteId] AS 'Site', wm.[WeekNumber] AS FacilityWeek, CONVERT(CHAR(10), GETDATE(), 103) AS 'WeekStart', CONVERT(CHAR(10),...

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

  5. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    = "https://api.ebay.com/ws/api.dll"; v_APICallName = "GetNotificationPreferences"; // // build header m_Headers = Map(); // siteID 3=UK, 0=US, check API Explorer Test Tool for others m_Headers.put("X-EBAY-API-SITEID",3);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 1 - 5 of 5

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Joes Word Cloud

Please publish modules in offcanvas position.