Would help to see the DDL for the Tables, TVF and the indexes defined with some sample data to reproduce the behavior. If it is not inline then a new...

Try this:

Go to the source connection, check the text file properties... make sure you have selected the checkbox Unicode.

You should also upgrade to SSRS 2016.... on the reporting side to support 2016 database.

-- Open the report and check for SQL is correct in the report.

-- Compare the table...

Link is going back to a topic written in 2012 which is an  entirely different.

You can give these a try:

a) Import Export wizard.

b) Use Excel directly, Connect to the Instance by creating a connection and retrieve the data in itself.

c) Use SSIS.

Note: From the data you provided  program_id from client_vist cannot be joined with client program because they do not match.

May need some code tweaks... to get the correct program_id code,...

Here is another way!!

-- Create a grouping column based on the difference between ID and row number within each usertier
;WITH CTE AS (
  SELECT *, 
...

What are these WT1, WT2...... in the output? Why 15 has to be shown under WT1 for B and not in WT2?

You can use CASE WHEN THEN ELSE END and...

Here is a sample script..... to get column usage metrics.

Replace DBNAME with your database name.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE   procedure  [dbo].[usp_Capture_TableColumnUsageMetrics] (@TableName  nvarchar(100))
as
begin

SET...

See if this helps...

I just provided for two scenarious using UNION, you can add the rest.. with actual columns and their table names

declare @Today date = getdate()

--...

PARSENAME is used by Jeff to extract the HOUR portion which is extracted by specifying 2 before a .(dot). Similarly 1 is used to extract the SECONDs portion after the...

I tried and found only ClientPrograms table is joined but not ClientEpisodes.  From the data provided for ClientPrograms and ClientEpisodes.  It looks like one-many relationship from ClientEpisodes to ClientPrograms.

Have you...

Ahh.. @Today is just declared while testing.  You can replace it with getdate().

Can you elaborate...

You can use s10, s11 and update if that is required. Otherwise it will provide the days difference between actual and schedule times.

declare @Today date = Getdate()

select...

Go through this link looks like there are few CU's released by Microsoft.

https://support.microsoft.com/en-us/topic/kb4058174-fix-heavy-tempdb-contention-occurs-in-sql-server-2016-or-2017-7082c14e-6c46-7b51-57b4-7ddfe63ac780