Well, I'm not really experienced with hierarchyid other than fiddling around with it.  Most of what can be accomplished with hierarchyid can also be done in various other ways.  In...

• This reply was modified 5 years ago by Steve Collins.

with t2_latest_cte as (
    select *, row_number() over (partition by RunDate 
            ...

When I run each query and include the actual execution plan the results are identical.  Both do one table scan and a constant scan on the results.  So yes they...

drop table if exists #Customer
go
create table #Customer(
  CIDint  not null,
  WholeSaler        bit not null,
  ReSalerbit not...

select year(eomonth(getdate(),-1))

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