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

  1. T-SQL example of Case-Sensitive Soundexhttps://joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    case is different, eg. "Data not yet available". The final system (qlikview) was case-sensitive despite our server collation being case-insensitive. Furthermore, we now have the task of finding all the variations of the default values which we found we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  2. Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

    that some default values get listed twice because their system was case-sensitive despite the collation of the SQL Server being case-insensitive. What? End-users said that they could see the options "Data Not Yet Available" as well as "Data not yet...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  3. Battery Constantly Drained on iPhonehttps://joellipman.com/articles/apple/battery-constantly-drained-on-iphone.html

    1 A friend reported her phone was constantly being drained, wasn't lasting the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down app until red minus buttons appear, tap red button)... I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  4. DataTumble - Randomize Data Rowshttps://joellipman.com/articles/database/t-sql/datatumble-randomize-data-rows.html

    ID = @ChosenID SELECT @UpdateData = Data FROM #Scramble WHERE ID = @ChosenId -- To dynamically update the Data in the field being scrambled SET @UpdateSqlStatement = ' UPDATE ' + @TableName + ' SET ' + @ColumnName + ' = @UpdateDataIn WHERE CURRENT OF...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *
  5. Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

    an office environment and we get prompted to login (with the same account as we're currently logged-in with???) instead of being able to just click on "Yes". How? The gist is that we're going to create a scheduled task (that won't be scheduled) and a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  6. Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

    work environment thanks partly to group policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in, this is the same user but re-prompted for credentials) Cannot run System Registry (not even DOS REG...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  7. SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    messages posted before this with more information about the failure. -- often when processing a datasource, the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put conditional statements to account for NULLs. --...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  8. Parse a HTML Table into a ListViewhttps://joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

    } LV_ModifyCol() Method #2 This method only uses two columns with the label being a concatenation of the value of the first column and the column heading. StringReplace,ReturnedHTMLTableRows,ReturnedHTMLTable,,|,A...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  9. SSIS Skip Rows in Excel Source filehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

    vary between "Microsoft Certified Professionals", just a piece of paper and proof you're good at theory IMO, no credit for being the tape monkey that does all the actual work.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    1:0 So based on this logic, the Employee "Joel Lipman" has a degree in Computer Science BSc and some qualification in being Superman. Specification The output expected by the customer is the following: EMP...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  11. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    public class MyConvertToProperTransform : PipelineComponent { // Create a variable which is used to identify the data column being processed private int[] inputBufferColumnIdx; // Create variables used in debug logging (when it is enabled) private...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. SSRS Stop Scrolling Behindhttps://joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

    no column groups). The headers do not stay fixed at the top of the page anymore but then this isn't the show-stopper; being unable to see the bottom of the report was.

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  13. Basic Android App using Google Maps and Current Locationhttps://joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

    one given to Google Maps. Follow On Article/Sequel Next: Article on separating the map into a sub-activity rather than it being the main activity - Android OS: Add GoogleMap as fragment.

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  14. Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

    Links XML parsing in PHP convert xml to json php curl utf16_decode PHP Manual: curl-setopt Well this is my stop. It's being several hours that for others could have taken a several minutes if you knew where to look. My aim was to convert UTF-16 received...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  15. Windows Live Mail Error ID: 0x8DE00005https://joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

    The error is that I can't receive/send messages on this account. The problem has something to do with DeltaSync no longer being supported. Deactivate the account by deselecting "include this account when receiving mail or synchronising" in the account...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB
  16. Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

    file. It is assumed that you have already registered the app with the Google developers console along with the redirect URI being this script. Complete the global variables at the beginning of the code specific to your app and the rest should work... //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  17. Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

    6 November 2018", I could want "Tuesday 6th of November 2018". Why? Well there's a long a way to do it (but reliable). But being limited to the lines of code you can run (ref. "Maximum number of executable statements", anything that reduces the number...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    this blank, the script will run through and connect to Google Drive using the Service Account. The script will work without being authorized, it just won't see any files other than its own. If you specify an impersonator and you have NOT authorized this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  19. Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

    the cell value is a number AND the cell data type is numeric. Search( is a case-insensitive search with the first parameter being the text to search for (can be a range) and the second the string to search (in this case a single cell value)....

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  20. Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

    of that month, subtract 1 day. .toEndOfMonth() used to work but appears to be deprecated. Invoice_Ref_ID is excluded from being copied as it was an autonumber in our example. zohoapis.eu is used in the above example for a client on the EU datacenters....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 41 - 60 of 93

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.