One way to select intervals where the drop off grouping is hierarchically preferred to the pick up grouping could be to divide the data into two groups: Group1 = BookingID's...

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

Old thread on a 7 year delay!  Minor correction to the earlier response tho.  For generic SQL statements the default is OFF, however, for TRIGGERS it's ON.  The documentation only...

Http verb-specific route handlers in .NET 6 filled the last missing piece of the data access puzzle

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 3 years, 6 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, 6 months ago by Steve Collins.

SSC is under massive attack from rogue travel agents 🙂