VSS KB Articles

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:


Removal tools (uninstall tools) for common antivirus software
8/10/2016
Removal tools (uninstall tools) for common antivirus software ,Avast,AVG,Comodo,eScan,ESET,FRISK F-PROT,Kaspersky,LavaSoft,Malwarebytes,McAfee,Microsoft,Norton (Symantec),Rapport,SpyBot Search & Destroy,Sophos,Trend Micro,Vipre,Webroot and Zone Alarm.


How to join a Windows 10 device to your Azure AD organization
8/6/2016
How to join a Windows 10 device to your organization


Android not Syncing with Exchange 2016 Active Sync service
8/3/2016
SOLUTION - Android not Syncing with Exchange 2016 Active Sync service


    

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