Knowing when to use the SQL COALESCE function is a lifesaver when you’re dealing with NULL. As ...

Read More

In this SQL minute we’ll look at how to create a SQL server hierarchical query using the ...

Read More

In this SQL minute we’ll look at how you can use hierarchyid to query hierarchy data.  This ...

Read More

A very common question I get asked is whether I can have a CASE Statement in the ...

Read More

Most people are familiar enough with basic SQL to be able to provide a simple explanation of ...

Read More