One way or another I would like to come up with a way to deal with JSON schemas.  If I observe how my time is spent and do the "5...

but my point is that I don't want to assign a value to a variable to start creating hierarchies for all accounts in my chart of accounts. Any ideas...

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