SQL – How to select current year from lookup table
This SQL query demonstrates how to retrieve the ID of the current year from a lookup table by utilizing the current date with GETDATE(), converting it to a year number…
SELECT
Excel 2013/2016 – How to split comma separated values into columns
Learn how to split comma separated values from one column into multiple columns using Excel 2013/2016 with this step-by-step guide. Perfect for…
Ubuntu – How to set VLC Media Player as default video player
This article provides step-by-step instructions on how to set VLC Media Player as the default video player in Ubuntu 18.04 and 16.04. Follow these easy steps to make your preferred…
SQL – How to select current financial year from lookup table
This SQL query demonstrates how to retrieve the current financial year from a lookup table by utilizing the current date, month, year, and cast functions. It returns the selected row…