Now that the Briefcase in SSC actually works I'm able to find old bookmarked threads.  This was a good one

https://www.sqlservercentral.com/forums/topic/replace-table-with-staging_table-approach

When there is no name provided for an array you could use OPENJSON without specifying a schema and then refer to the array as '[value]' (with appropriate table/tvf alias'ing) in...

The trigger "prevents" (assuming READ COMMITTED only)...

Speculating regarding temporal tables what if you defined ORIGINAL_LOGIN() as the default value of a column in the base table and use a trigger to prevent it from being overridden...

Here's the screenshot!  Congratulations again Jeff Moden and THANK YOU for everything 🙂

Thank you Professor Moden!  Congratulations in advance for passing the 1,000,000 point milestone.  I appreciate and learn from you all the time and I hope you get...

Sure, the function code is below.  It was taken from this article

CREATE FUNCTION [dbo].[fnTally]
/**********************************************************************************************************************
    Jeff Moden Script on SSC: https://www.sqlservercentral.com/scripts/create-a-tally-function-fntally
**********************************************************************************************************************/
   ...

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 4 years, 1 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 4 years, 1 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
...