Advanced Search

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

  1. Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

    are cases in T-SQL where the trim is unecessary and a similar equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE @EmployeeStr = 'JOE ' + CHAR(9) +...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  2. Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

    default value. In this specific case, we are giving it the label value to indicate to the user to enter their Name (as in forename or surname). onFocus() - What to do when the user moves their cursor into the field or clicks on it. In this specific...

    • Type: Article
    • Author: Joel Lipman
    • Category: JavaScript
    • Language: en-GB
  3. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

    about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference = @GivenRef OR @GivenRef ='') AND (Forenames LIKE @GivenForenames + '%' OR...

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

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

Please publish modules in offcanvas position.