Worked . Thanks

EXCEPT gives one to one match in all cases. I want conditional matches depending on case by case basis.

splitting the values into separate rows is not an option .

These are two separate tables coming into SQL from SharePoint list . I need to provide a gap report where the countries do not match.

1. Perfect match
2. Fuzzy match as...

I just corrected the data size. Thanks for pointing that out.

Sorry, it was my mistake . Should be 'EME HQ,EUR HQ,KSA HQNME HQ'

Master controlling record is the ID . If there are duplicates for MARKET for same ID then keep one value for the Market and update the rest to 0.

If there...

Thanks for the queries above. For the PL update, it's not working as expected .

It seems impossible to me too. However, when I track back with TaskUID in both TaskTable and SharePoint list ,I get exactly the same record.

The packages are located on a shared folder in the server which all team members has access to . We are trying to open these packages from the server and...

That's the only error message I am receiving.

Hi,

Thanks for replying. I am trying to open the project containing the packages . The other developer follows the exact same steps on the server and he is able to...

I was trying to debug the issue and found out if I exclude this value

'M&S Management and Distribution x Balance Products and Materials' then I don't get the error ....

Taking your code, and attempting to make sense of your description, this is what I think you are trying to do:
1. Add the AD group 'Database_readers' as a login...

Does the firewall rule simply allow the users to connect to the server from their desktops, or does it allow them to RDP to the server?  - Firewall rule allows...