VSS KB Articles

How to disable cache in Firefox
12/4/2018
How to disable cache in Firefox, Type in the address bar about:config,Type in the search bar browser.cache


Windows unable to upgrade due to USB install of OS
10/21/2018
Windows unable to upgrade due to USB install of OS Windows 8.1 / Windows 10


How to Configure DNS on a Domain Controller with Two IP Addresses
7/12/2018
How to Configure DNS on a Domain Controller with Two IP Addresses; Configure DNS on a DC with two IP addresses


How to safeguard from the SWEET32
7/12/2018
How to safeguard from the SWEET32 Issue, CVE-2016-2183, Disable RC4 and 3DES on Windows Server


Redirect from HTTP to HTTPS using the IIS URL Rewrite module
2/12/2018
This is the most common requirement on most of the Exchange servers hosted on IIS. The server admins configure an http to https redirect.


    

5/10/2011
How to Combine columns with NULL values in SQL 2008 R2

How to Combine columns with NULL values in SQL 2008 R2 using coalesce

I ran into a problem where a NULL value was preventing the rest of the other columns I was trying to combine fail for UPS WorldShip interface.  I discovered that coalesce would be my solution for the issue.  I have profided a working sample below for reference:

/****** Object: View [dbo].[UPS_View] Script Date: 05/10/2011 03:16:03 ******/

SET

 

ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,

 

 

 

QUOTED_IDENTIFIER, ANSI_NULLS ON;

 

GO

SET

 

QUOTED_IDENTIFIER ON

 

 

GO

 

 

 

ALTER

 

VIEW [dbo].[UPS_View]

 

AS

SELECT

 

dbo.ac_Orders.OrderNumber, coalesce(dbo.ac_OrderShipments.ShipToCompany,'') + ' ' + coalesce(dbo.ac_OrderShipments.ShipToFirstName,'') + ' ' + coalesce(dbo.ac_OrderShipments.ShipToLastName,'') AS [ShipToName], dbo.ac_OrderShipments.ShipToAddress1, dbo.ac_OrderShipments.ShipToAddress2,

 

 

dbo

.ac_OrderShipments.ShipToCity, dbo.ac_OrderShipments.ShipToProvince, dbo.ac_OrderShipments.ShipToPostalCode,

 

 

dbo

.ac_OrderShipments.ShipToCountryCode, dbo.ac_OrderShipments.ShipToResidence

 

FROM

 

dbo.ac_Orders INNER JOIN

 

dbo

.ac_OrderShipments ON dbo.ac_Orders.OrderId = dbo.ac_OrderShipments.OrderId

 

 

 

 

 

GO