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, 1 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

ORM only makes sense if the mapping is necessary, no?  Otherwise, if it's easier to not use ORM then it becomes a waste to use it.  Imo since .NET 6...

IQP is important because there are more processes reading the database, not all of them written by developers.  Some are generated by reporting tools or ORMs.  This sort of...

with rn_cte as (
    select *, eow-[Week] wk_diff,
           row_number() over (partition by it, cg,...

In Visual Studio if you hold the Alt key down while using the mouse to highlight text it rectangularly selects areas.  Because the dates are horizontally aligned with just a...

No comment on the date calculations?

declare @start_yr           int=2022;

with months_cte(mo_num) as (
    select * from...