It could be CRUD but only when implemented by Scrum.  Or maybe it's a framework which launches projects miles over the horizon where they explode.

You could try putting CASE logic inside the SUM functions to evaluate your youdatecol

...
ISNULL(SUM(case when youdatecol>=convert(date, getdate()) 
         ...

;with
id_split_person_cte(id, [Owner], ItemNumber, [PersonAttending]) as (
    select sctr.id, sctr.[Owner], splt_person.ItemNumber, splt_person.Item
    from #SplitColumnsToRows sctr
       ...

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

Got any more examples?  It appears there are 2 sets of rules for the 2 different scenarios:

Scenario 1) Owner='' -----> (if [Owner]='' then PersonAttending and Type columns are CROSS JOIN'ed)

Scenario...

It seems the data is ordinally JOIN'ed between PersonAttending and Type and CROSS JOIN'ed between PersonAttending and Owner.  To do the ordinal splitting this uses dbo.DelimitedSplit8K_LEAD.  Ordinal splitters and specifically...

Similar to the accepted solution but without the common table expression.  It appears Jeff began to code it one way and then switched

select max(case when sp2.ItemNumber=1 then...

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

The additional rows were generated using dbo.fnTally

select case when fn.n=0 then k.CDMLOCID else '"' end CDMLOCID,
       case when fn.n=0 then...

Hmmm it's hard to be certain without testing.   I've had issues with inserts of multiple rows with the same system datetime into System Versioned tables.  It's the "simultaneous" part it...

If I'm understanding this could this be done in the WHERE clause with a bunch of OR conditions.

select * 
From Master as pom
WHERE Pom.UserID = @userid
 ...

Have a look at the Docs for SUBSTRING

SUBSTRING ( expression ,start , length )

When the CASE statement is evaluated as TRUE, because you're adding +1 to the length LEN...

Yes the repository is the better place for the code.  There are going to be many changes and now this thread seems incomplete.  Maybe it makes sense to start over...

Hi Steve Jones, when these posts were consolidated from what were originally 7 separate threads it appears a post(s)? containing the DDL and explanation for having a System Version'ed edition...

It's been a few weeks since there's been an update.  We've had some work upheaval and also my son's 6th Birthday party and the Memorial Day holiday.  Workwise I've been...

The function could be included in the SELECT list

select lcd.LoggerDownloadTableName,
       smalldatetimefromparts(substring(lcd.LoggerDownloadTableName, 18, 4),
        ...

You could try SMALLDATETIMEFROMPARTS

select v.input, 
       smalldatetimefromparts(substring(v.input, 18, 4),
            ...