MS SQL Server 2008 – How to update value using SELECT results
The following T-SQL shows how to update a value using the results of a SELECT query. This applies to Microsoft SQL server (T-SQL) -- and will not work in MySQL.…
SELECT
SQL – How to get current financial year using SQL
The following SQL shows how to get the current financial year using SQL. This assumes that the financial year for your country is 1 July - 30 June. This SQL…
SQL – How to select current financial year from lookup table
The following SQL shows how to select a row from a table using the current financial year as the WHERE condition. This is useful if you have a table of…
Three ways to wipe a USB drive from Windows
CAUTION: The steps below will completely wipe the data from the USB drive you select. Make sure you choose the correct drive and backup any files on the drive you…
WordPress – How to use IN in WPDB PREPARE SQL statements
In an SQL statement, the IN operator allows you to multiple values in a WHERE clause, for example: SELECT * FROM 'table' WHERE 'field_id' = 1 AND 'field' IN (…
WordPress – How to use LIKE in WPDB PREPARE SQL statements
In WordPress, the WPDB class is available for interacting with the database, for example reading or writing data. The PREPARE method is almost always used along with the WPDB. PREPARE…
SQL – Return TRUE/FALSE if query rows returned
Here's a little trick you can use to return TRUE/FALSE if a query has returned results. For example if a Person is in Category_ID 325 or 326 we want TRUE,…
SQL – How to concatenate/combine column values into comma separated text string
The following SQL statement shows how to combine a column into a single text string - separated by a comma. For example: Name Fred Jim Jane Betty Would be combined…
SQL – How to format decimal to space delimited currency $ 1 234 567.89
The following SQL statement shows how to take a decimal value, e.g. 1234567.89 and convert it to a space delimited currency - that is, instead of using commas to separate…