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 3 years, 4 months 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...

yes - you need to create a login from credential (not login from windows) and then add that login to the required dbs as needed

it would be better you show us the code you are using for this as well as details of server/version

and what was the fix? its good to post the solution in case any other users face the same issue.

Sharing a report does not require a PRO license only - only PUBLISHING a report to a server requires that licensing.

Assuming you are talking about using powerbi on cloud -...

No... its Sunday... special extended weekend 🙂

regarding the update to null - depending on the frequency of that table being updated you may be able to create another table with same structure (including indexes), insert all...