I'm not quite sure what you're trying to do here.
Where exactly do you want to add the +1?
Is it an extra column, or do you want to update...

It's not totally clear what you want, but here are a couple of ideas:

(I've changed the column name to "PrincipalBalance".)

-- Show only...

USE [tempdb]

DROP TABLE [dbo].[Test1];

CREATE TABLE [dbo].[Test1]
(Item Varchar(10), [Type] Varchar(20), Cost_Of_Sales Decimal(12, 6), Quantity Int);

INSERT INTO [dbo].[Test1]
VALUES
('11827350',        'Parts',    11.5,        2),
('11827350',        'Service',    5.880235,    2),

This uses a pivot table...

USE [tempdb];

CREATE TABLE dbo.Requested
(Pkey Int, ParentId Int, [Status] Varchar(50), Datelogged DateTime);

SET DATEFORMAT DMY; -- To get...

How about this:


SELECT KidID, MAX(EndDate) as MaxEndDate
FROM [dbo].[Payments]
WHERE EndDate < GETDATE()
GROUP BY KidID;


Hi - Have you still got a problem with this?

I ran it & it worked OK, as it stands:

USE [tempdb];
GO

DROP...

Left join to Udf table filtered on 25 only, & only show staff with no join:

SELECT Staff.Person_id, Udf.value as Value, Staff.Forename, Staff.Midname, Staff.Surname,udf.field_id,
Staff.employment_end
FROM...

Is this a locale issue?  What country are you in?

Try


SELECT Color
FROM mytable
WHERE Seq = (SELECT MAX(Seq) FROM mytable)


I think that message means that you have got a value that's not a date somewhere in the column.
It's not a blank or an invalid date.

What format is the character date?

This might come in handy:


SELECT  [TableName] = OBJECT_NAME(object_id),
last_user_update, last_user_seek, last_user_scan, last_user_lookup
FROM  sys.dm_db_index_usage_stats
WHERE  database_id = DB_ID('MyDB')


See: https://sqlandme.com/2014/03/11/sql-server-how-to-get-last-accessupdate-time-for-a-table/