The way to restrict the number of rows the MERGE is applied...

Since you're counting across months the quick way to generate the daily rows would be to use a tally function.  This uses dbo.fnTally which see this link for details. ...

It's impossible to say with certainty but perhaps there's another process which causes locking?

Maybe you're looking for something like this

Declare @PalletContent table (ID                int,
 ...

If the MERGE throws an exception is there a rollback?  Could you post the whole procedure?  Is the lock still an issue or it's inconsistent?  Broken MERGE statements are a...

Receiving JSON and putting it in SQL tables (and the reverse) is pretty much what my job entails these days.  It seems like there ought to be an SSIS way...

Step 1 could be to summarize by the concatenation of MODEL and VARIANT.  Then further summarize by year (årgang) and use STUFF+FOR XML to aggregate the concatenation of MV_ANTAL and...

Hi there -- thank you for the points 🙂  It wasn't clear to me it's OK to use the uniqueid to order the results.  Windowing functions are permitted in the...

My answer was posted on Stack Overflow.  It assumes as little as possible about your data.  The final result isn't in the same order as the example output because...

A non-dynamic crosstab query to produce the output above could be something like this

with names_cte as (
    select *, row_number() over (partition by department,...

Are the names within departments in any particular order?

My goal is to come up with questions

It's called gaslighting.  It's such a shame and it makes me sick to read this.

The two most consistently awful crap slingers are also the two highest ranked members.  Coincidence?  Meh, I don't think so

The...