what you need is to convert your script to something more clear and easier to maintain - and more robust as well.

from what I can see your intention is to...

• This reply was modified 4 years ago by frederico_fonseca.

if you are using SQL Azure or a contained database then you can't reference other db's - you need to know what you can and can't do with your particular...

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

it should be sys, not dbo

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

it should be sys, not dbo

• This reply was modified 4 years ago by frederico_fonseca.
• This reply was modified 4 years ago by frederico_fonseca.

you are not seeing what you wish because of how the row_number works (did you go and read the manual I gave?) - and as you didn't look at the...

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...

this is SPAM - not flagging it yet but no point in anyone responding to it.

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...

• This reply was modified 4 years ago by frederico_fonseca.

look at the data - I gave you a pointer with a sample to what you need to look at - but it is your data, your rules and you...

as to us avoiding wasting time kindly tell us what software and db engine you are using.

with regards to trying to identify your issue change the select bit to be...

before we waste more time with this can you tell us what is the db engine/software you are using and why using a CTE is not possible - and what...

following the above... if you hide the error message then your code is fine and you are good to go (for a beer)

are you using any specific connector for D365 or are you doing straight SQL inserts/updates? if SQL then instead of trying to process that in SSIS load both headers and...

yes. do it as a SQL Server Agent Job - powershell script and load results to a table on SQL.

hum... I would not do it - use the correct UI https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver16  as it does a bit more behind the scene - and while you are at it change...