Hi Frederico,

Are you able to clarify please?

Hi Frederico

Are you suggesting that I replace:

@EnrichedViewDatabase

With

'EXEC [' + @EnrichedViewDatabase + '].dbo.sp_executesql @'

Hi Frederico,

Thanks for getting in touch.

Yes, I have read the manual.

The manual states to hardcode the database name

Hi Jeffrey,

I am now getting the following error:

'testdb.dbo.sp_executesql' is not supported in this version of SQL Server.

Would you happen to know version of SQL Server that supports sp_executesql?

Interesting - I was hoping I could achieve the result with the existing database. I will try with a new database.

Thanks

have you been able to determine what is needed here?

TBH, my boss didn't like my approach to finding a solution to the issue - kinda echoed some of your sentiments...

Jeffrey,

I have fully read your comments - multiple times 🙂

I think I have been schooled - in a nice way. I have spent the last hour studying both tables, and...

Jeffrey

I have just seen your response - its quite late here in London for me to reply in detail, but I just wanted to say I’ve glanced over response I...

Hi Jeffrey,

Thanks for getting in touch.

"Many questions have been asked for additional information, table definitions, sample data *and expected results*."

I have provided all of the above - tbh, some might...

It was code that was provided to me to fix an issue.

Its hard to determine the number of rows that will be matched.

The thing that is troubling me is that...

Hi Frederico, I think you're referring to one of my previous questions :-). I haven't asked for help in removing CTE's in this question 🙂

Also, part of the question, 'why I get output with table ending _copy and not the other table ending _why'?

Hi Frederico,

I really appreciate what you're doing for me, and may be its because I'm under pressure that I'm not fully understanding what you're driving at. However, I am working...

I just realised that I didn't give you sample data for the appointment table. Maybe it shed some further light on the problem

CREATE TABLE appointment (
 ...

Frederico, I'm confused.

How does the following code, give me the results I need:

SELECT C1.Id
, C1.SinkCreatedOn
, C1.SinkModifiedOn
, C1.statecode
, C1.statuscode
, C1.prioritycode as C1_prioritycode
, C2.prioritycode as C2_prioritycode
, CASE 
WHEN ISNULL(CAST(C1.prioritycode...