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

  1. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    AS [First] , MAX(ExecutionLogStorage.TimeStart) AS [Last] , CAST(CONVERT(CHAR, DATEADD(millisecond, MAX(DATEDIFF(MILLISECOND, ExecutionLogStorage.TimeStart, ExecutionLogStorage.TimeEnd)), '00:00:00'), 121) AS TIME) [High] , CAST(CONVERT(CHAR,...

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

  2. Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    , e.[TimeDataRetrieval] AS [Data Retrieval] , e.[TimeProcessing] AS [Process Time] , e.[TimeRendering] AS [Render Time] , DATEDIFF(MILLISECOND, e.TimeStart, e.TimeEnd) [Total Time] ,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank] FROM...

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

  3. AHK Countdown Tooltiphttps://www.joellipman.com/component/content/article/ahk-countdown-tooltip.html?catid=48&Itemid=165

    UpdateMessage: ; TOTALS ThisManySeconds:=DateDiff( A_Now, FinalDate, "s" ) ThisManyMinutes:=Floor(ThisManySeconds/60) ThisManyHours:=Floor(ThisManySeconds/3600) ThisManyDays:=Floor(ThisManySeconds/86400) ThisManyWeeks:=Floor(ThisManySeconds/604800)...

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

  4. The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

    [TimeDataRetrieval]+[TimeProcessing]+[TimeRendering], '00:00:00'), 121) AS TIME) Unaccounted time. SUM(DATEDIFF(MILLISECOND, TimeStart, TimeEnd)) [TimeTakenSum] AVG(DATEDIFF(MILLISECOND, TimeStart, TimeEnd)) [TimeTakenAvg] LEFT(CAST(CONVERT(varchar,...

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

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

    DECLARE @StartDate DATETIME, @EndDate DATETIME --First day of current month SET @StartDate = DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) --First day to display on calendar SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate)...

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