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

  1. Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

    Below it you should see a list of visual effects, some of which will be unchecked if you are not experiencing the full range of Aero features. Select the custom option and then select all the effects from the list below it. Hit apply and ok and you...

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

  2. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    THEN 1 ELSE 0 END; -- DETERMINE TIME VALUE IF TIME WAS IN GIVEN VALUE IF @DateMatch=1 BEGIN -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago...

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

  3. DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/else/database/t-sql/datascramble-randomizing-data-rows.html

    THEN 1 ELSE 0 END; -- DETERMINE TIME VALUE IF TIME WAS IN GIVEN VALUE IF @DateMatch=1 BEGIN -- SET YEAR RANGE (1912 - 1994: for Birthdate specifically: Older than 18 but younger than 100) SET @MinYear = DATEPART(YEAR,GETDATE())-100; -- 100 years ago...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • 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

    to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and Microsoft's SQL Server Reporting Services interface isn't the most...

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

  5. SSRS Subscriptions cannot be createdhttps://www.joellipman.com/component/content/article/ssrs-subscriptions-cannot-be-created.html?catid=75&Itemid=165

    user with read-only privileges. The report has 4 parameters, two of them use the default values (from and to date range) and two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where...

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

  6. Excel: Extract hyperlink from linkhttps://www.joellipman.com/component/content/article/excel-extract-hyperlink-from-link.html?catid=110&Itemid=165

    and Paste the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End Sub Press F5 and click “Run” Get out of VBA (Press Alt+Q)

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
Results 21 - 26 of 26