It looks like you are using string manipulation to convert your CoverageEffectiveDateKey and CoverageEndDateKey from yyyymmdd format to mm/dd/yyyy format.  DATEDIFF is perfectly capable of handling strings in yyyymmdd format, so don't...

Let me put this another way.

December 15, 2017 at 9:39 am

#1972315

You should also know that you can use CTEs to partially control the order of processing.  The entire CTE has to be evaluated before it can be used later in...

Please post expected results.

Drew

December 14, 2017 at 7:59 am

#1972143

You haven't defined the relationship between the table that you are updating and the source data, so it's as if you're updating every single row in the table with every...

And instead of using MONTH() try using DATEPART(QUARTER, <yourdatefield>)

Drew

Here is an alternate method that does not require a pivot.

SELECT
*
FROM OPENXML(@hDoc, 'appt_links/appt_link',1)
WITH
(

[ResourceID] [nvarchar](10) 'Field[@name="ResourceID"]',
[FromActivityID] [nvarchar](10)...

My solution is to use the right tool for the job.  In this case it's a reporting tool such as SSRS.

Drew