In a CTE you could select the date difference between the CreatedDate and the LEAD(CreatedDated, 1, default) where the default is the current month (+1 to deal with boundary crossing). ...

Just a quick venting/raging......Entity frameworks using code first is the spawn of the devil himself. It is seriously one of the worst anti-patterns I have ever seen. Thanks I...

It's another case of no sample data.  If the hierarchyid's are conventionally formed using '/' delimiters then they can be ordinally split.  One way to derive the original adjacency could...

• This reply was modified 3 years, 8 months ago by Steve Collins.

I have a fellow that's trying to resolve some performance issues in a HierarchyID-based table.  I just don't use HierarchyID because I've found or made better ways to work...

• This reply was modified 3 years, 9 months ago by Steve Collins.

SSC is under massive attack from rogue travel agents 🙂

Wading in without any knowledge of Azure Data Factory at all... it seems like maybe the system is expecting a "pagination_token" along with the initial request?  You're telling it how...

Why does a single datetime of a "mess up" apply to every vehicle worked on subsequently during that day?  What if the mistake was made at 11:59PM there's only 1...

Seems similar to the other recent question

with parts_cte(partid) as (
    select partid 
    from #temp
    group by partid
...

Similar to kaj's code

with unq_prs(GivenPartNumber_Non,vcompanyid) as (
    select GivenPartNumber_Non,vcompanyid
    from #notmappedsources
    group by GivenPartNumber_Non,vcompanyid
    having...

Imo three triggers would be preferred.  Right from the start it's confusing because it's a "catch all" for the 3 scenarios, INSERT, DELETE, UPDATE.  In code each scenario is intended...

The first CTE (named 'UDT_CKB_SNAPSHOT') contains GROUP BY but no HAVING clause and no aggregate function(s) in the select list.  It's equivalent to SELECT DISTINCT which is much more readable. ...

• This reply was modified 3 years, 9 months ago by Steve Collins.

Maybe try it without the VIEW

Perhaps the spaces are present in the input data.  One quick way to get past the issue could be to import into a staging table and then use a query...

The thread is a duplicate.  Regarding just the first 4 lines of the procedure

Begin
-- these 2 should always be set in ALL sp's
--  set nocount on;...

It happened to be an article (which I vote yes also to keeping open) but idk it could've been a regular forum post.  Those come up in searches.  A new...