Maybe you're looking for the SUM OVER the volume partitioned by the 'parent_id' column but which column is appropriate to ORDER BY?  If ORDER BY the 'filter_path' column it causes...

It's true.  It's available in Azure SQL compatibility level 150 (and above) and SQL Server 2022.  There are alternatives such...

drop table if exists #some_table;
go
create table #some_table (
  input_string varchar(200) not null);

insert #some_table(input_string) values
('5,1,6,1,69,1'),
('5,1,6,1,3,2,5,3,69,1');

select string_agg(iif((ss.ordinal-1)%2=0, concat('''', ss.[value], ''''), ss.[value]), ',')
      ...

Maybe something like this

drop table if exists #some_table;
go
create table #some_table (
  full_name_proper varchar(200) not null);

insert into #some_table values
('A'),
('A B'),
('A B C'),
('A B C D'),
('A B C...

You could try OPENJSON and provide the 2 column schema definition

declare @json           nvarchar(max)=N'[{"display":"Section1","value":"1"},{"display":"Section2","value":"2"}]';

select oj.[value], oj.display
from openjson(@json) 
...

The windowing function FIRST_VALUE returns the first value in an ordered set.  In this case PARTITION BY item_num ORDER BY revision.  You could use a CTE to UPDATE the column...

In SELECT statements the FROM clause and JOINs are evaluated first.  Maybe you could use the VALUES table value constructor to store (rows of) criteria, order number, and value.  Then...

At this point no I haven't downloaded the desktop app.  I did look around some more at the Blazor razor pages.  In that area in general you seem to be...

(another attempt to fight the anti-spam forum measures)

EF isn't used at all for the interesting parts. I just added it 2 weeks ago and it's only used by the...

The GitHub link is only visible in the footer of the demo/query section of the site

https://github.com/jtheisen/squil

Entity Framework is just used for configuration purposes, the actual data access during browsing...

Very interesting.  It looks impressive and the site works great.  The GitHub repo (+1 star'ed) is always the interesting part imo.  It seems maybe the project began a while ago...

You could nest the current formula inside an additional CONCAT function and test for the existence of the lead characters

 SELECT  tt.homepage_url
    ...

• This reply was modified 3 years, 9 months ago by Steve Collins. Reason: LEFT(String, 4) is a better comparison than CHARINDEX

Does the query return the expected output?

One place to keep important SQL-related information for me is SSC's Briefcase feature.  For a while after I became a member it wasn't working (at least for me using Chrome...

Avoidance is the easy way imo