You can use the Lead function to get it

Drop table if exists #t
go

Create table #T (
RowNum int
,Id int
,IndividualId...

Here's a recursive CTE that returns the values you want.  Seems you wants the contiguous keys and ignore all the noise in between

Drop...

Does this work for you?

drop table if exists #Temp

Create table #Temp(
LoanNumber varchar(10),
Inspectiondate varchar(10)
,Marketvalue float
);
Insert into #Temp values (12345,'2017-05-19',975000.00)
Insert...

Can you provide some data and DDL for the tables?

Looks like a corrupt index, similar to this  https://www.sqlservercentral.com/Forums/Topic1401804-2893-1.aspx

I hope this isn't a homework project, otherwise, I'd have to ask What are they teaching them, deprecated syntax?

SQL introduced Try_Cast in 2012.  Leaves out any hard coding

select input,
     Case when try_cast(input as Date) is null
            then case when try_cast(input as int)...

Why would you constantly be polling?  Why not setup a job to run once an hour or 2 to look for these conditions?  Then modify the payment process to update...

Try a dynamic pivot

Drop table if Exists #T

Create table #T(itemID varchar(20),
           Description varchar(100),
                 Title varchar(20),
                 IndexID smallint,
                ...

Sounds like a left join and Case when will do the trick.  Without any real data and expected results, it's hard to give you an answer.

I think you might be getting confused with more than 1 parameter.  If you Declare @TicketNo bigint...

did my change not work for you?

Try changing varchar(8000) to varchar(max).  Worked for me

USE msdb;
GO

DECLARE @SourceSchema  SYSNAME = 'dbo',
  @SourceTable  SYSNAME = 'backupset',
  @TargetDatabase SYSNAME =...