Does the public role have read access to those tables? I don't think you can remove a user from public.

You could create a new role, add the user to the...

• This reply was modified 2 years, 10 months ago by  Ed B.

You original post talked about 1's and 0's.  You've now post data with only 1's and haven't posted the result that you're looking for.  I don't know about anyone...

• This reply was modified 2 years, 10 months ago by  Ed B. Reason: Format code

SELECT GivenPartNumber_Non, vcompanyid, MAX(SourceType) AS 'SourceType'
FROM   #notmappedsources
GROUP  BY GivenPartNumber_Non, vcompanyid
HAVING MAX(SourceType) = 484456
AND    MIN(SourceType) = 484456

and for fun.

DECLARE...

• This reply was modified 2 years, 10 months ago by  Ed B.

Can you join your No Match destination table to the...

The problem is that the no match output includes rows that you think should be in the match output, is that correct?

Do you have mixed upper and lower case text...

Are your statistics outs of date on the Parts.ManufacturingData table? PartID is the primary key and is the join, but the estimated rows for the clustered index scan is 33...

I am struggling to understand your requirements, and your suggested query references columns that do not exist anywhere in your code ([Contract Status] and [Date ID]). I am also unclear...

• This reply was modified 2 years, 10 months ago by  Ed B. Reason: Format code

You should have removed the Identity attribute from the AccountKey of your temp table !!! ( as you may end up with different AccountKey values in your tempdb !!!...

• This reply was modified 2 years, 10 months ago by  Ed B.

I think I read the same page as you did, based on the query you posted. It indicates that the problem is that the amount of memory available for locks...

• This reply was modified 2 years, 10 months ago by  Ed B.

It sounds like you only want to use the guid to join to new contacts in the on-prem table. Is there anything in the on-prem table that tells you it...

If you only care about users' first subscriptions, can you assign a number of days until first subscription to every user?

Then assign each user an offset code (D1, D30, D90,...

You could probably use TRIGGER_NESTLEVEL to do that.

I tend to use session context values instead, set via sys.sp_set_session_context and SESSION_CONTEXT(N'<key_name>').  If you want more info on this method, let...

I don't think you need a function to split the table. I think you need to work with your data to create two tables, shifts and events, containing start and...

Does this behavior occur only with upgraded packages? Or does it affect all connections made using the new oracle source? even in a new project created in SSDT 2019?

Yes! I forgot that the query was inside brackets.