T-SQL – How to output ordinal number – 1ST 2ND 3RD 4TH
The following T-SQL statement shows how output a number as an ordinal number (st, nd, rd, th). For example, 3 would output 3rd. How do I use this? Replace '3'…
REPLACE
T-SQL – How to output ordinal day from date – 1ST 2ND 3RD 4TH
The following T-SQL statement shows how output the day from a date as an ordinal number (st, nd, rd, th). For example, 16 March 2019 would output 16th. How do…
How to change decimal precision using Notepad++
I recently had a large JavaScript array - a complex polygon of latitude and longitude coordinates. The file was undesirably large (about 32 MB) which seemed to stem from the…
How to replace character with new line using Notepad++
The following steps show how to convert a character (for example a tab or comma) with a new line using Notepad++. For this example we'll be converting The,Quick,Brown,Fox,Jumped,Over,The,Lazy,Dog to The…
SQL – How to copy column data to another column
The following SQL statement shows how to copy the data from one column to another. It will replace any existing values in the destination column - so be sure to…
SQL – How to convert line separated text to comma separated
The following T-SQL for Microsoft SQL Server shows how to convert line separated text to comma separated text. For example, if we had a table with the following data Lucky_Numbers 2 33…
Excel 2016 – How to exclude (blank) values from pivot table
If you need to create a pivot table chart on a range that includes blank rows you'll end up with a (blank) label. There are several suggested ways to remove…
SQL -Find and replace text in string
The following T-SQL for Microsoft SQL Server shows how to find and replace text in a string. In this example we'll change "PO Box" to "P.O. Box". The REPLACE function will search for…
PHP script to test HTTPS secure connection through proxy server
The following PHP can be used to test if a web server can make a https connection through a proxy server. This can be useful if you need to test…