I agree with Michael. Don't complicate things. Use a third node.

Use COALESCE()

SELECT
     Id
   , FinalValue = (ISNULL(Val1, '') + ', ' + ISNULL(Val2, '') + ', '
    ...

I completely agree with you, the cloud is where things are heading. Probably not everything. Or if it is everything, it won't be all at once. But its definitely...

There are three important things to think about when considering moving to the cloud.

1. In the UK, and I assume in other countries, you can write the depreciating cost...

Quite a set of trips. For me, we've planned a camping trip with horses to South Dakota, riding the Custer area. We also take my daughter to university in Aug,...

That's not good enough for most CPAs, my Mom, and lots of other business users. The online version seems to be a last resort for most people.

I wonder if we'll...

The example won't work with anyone that doesn't have the same named instance name as me. This isn't intended to be something you follow without changing paths.

Your point about default...

I think that the authentication on Linux is still a hassle. I know some people have it working, but it certainly isn't easy right now. That will get lots of...

Autoshrink - never. I mean, I've struggled to think of a scenario where this makes sense. Paul Randal, who managed and wrote code for the storage engine thinks this should...

That's a skill in and of itself. Comments should go through the PR, but if not, I would hope your client allowed click through to the original branch for the...

Never used it myself. Just stumbled on it.

No idea. Maybe use XE and see what the difference is, grab the plans.

+1 for simple mode

I am aware of that now, having gone from 15-20C temps in May in Colorado to 4-15C in ANZ in June. I have an appreciation for time and weather down...

Turbo does this for apps on...