This should work:

select *,
[test33] = CASE WHEN PrgFld NOT IN ('XXX') THEN ROW_NUMBER() OVER(PARTITION BY VID, Acc, nullif(PrgFld, 'XXX') ORDER BY OrdDate) ELSE 0 END

Jeffery never said anything of the sort.  Simply, if you do not need the extra precision of a datetime2, as well as the extra byte of storage required,...

Forget about precision - I already stated that if you need that precision then use that data type.  That isn't the issue - the issue is that there are known...

I have been watching this conversation about COBOL - and I find it to be rather funny.  I started working in this industry on a little known platform called MUMPS...

Neither of these solve the OP's question:

For this particular scenario the following would also work with no need for the Partition By clause.  Why get fancy when simple will...

I think all you need is this:

SELECT *
     , [test2] = CASE WHEN PrgFld NOT IN ('XXX') THEN ROW_NUMBER() OVER(PARTITION BY VID, Acc...

• This reply was modified 2 years, 4 months ago by Jeffrey Williams.

Do you need to convert the dates ?  Isn't this OK ?

INSERT INTO homes.Properties
VALUES
(1, 1, '12a, Station Street, Liverpool', 500, '2019-12-31' )
,(2, 1, '12c, Station Street,...

Or you need to include that information in the calls to SQL Server - as in a parameter to a stored procedure (e.g. User, UserID, etc.)

It really depends on the size of the team - and the knowledge and ability of all team members.  I see no reason to limit a "DBA" from developing if...

Using SSMS - run the following connected to that instance: SELECT @@VERSION.

If the version you see is SQL Server 2019 Express Edition - that would explain why SQL Server Agent...

It all comes down to your RPO/RTO - and whether or not DPM can meet those requirements.  The first test I would perform is a straight native compressed backup and...

Change the size to a fixed MB - then shrink the file to as small...

Let's deal with the first issue - the autogrowth setting is incorrect.  You have it set to...

Of course it will work. Put your database in simple mode, shrink your log file and go on. That's my daily work, works always and that's...

I have a few questions that need to be answered first.  If the OP responds then we can see if there are any available options.