VSS KB Articles

Setting up GMAIL on Outlook
7/19/2017
STEP #1 - Allowing less secure apps to access your account STEP #2 - Set up Google Gmail servers STEP #3 - Set up proper secure transportation ports


How to manually uninstall Microsoft Intune Agent
6/12/2017
How to manually uninstall Intune agent manually using the ProvisioningUtil.exe


How to migrate 2003 AD Server to 2016 AD Server
5/31/2017
The step by step instructions to upgrade Windows 2003 AD to 2016 AD.


How to Setup VPN Connection Windows 10
1/30/2017
Connect to a VPN in Windows 10 Whether it's for work or personal use, you can connect to a VPN (virtual private network) on your Windows 10 PC. A VPN connection can help give you a more secure connection to your company's network and the Internet


How to I export email addresses from Comcast Webmail
1/11/2017
How do I export email addresses from Comcast Webmail? You can export your contacts from Comcast Web Mail (or Comcast SmartZone) into a spreadsheet by following the instructions below:


    

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