TSQL

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...

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...

SQL – How to select current year from lookup table

The following SQL shows how to select a row from a table using the current year as the WHERE condition....

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...

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...

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...