This tweak seems to solve the issue

Select @requested_qty = CAST(@requested_qty as float) * (@conv_fact_nr /@conv_fact_dr)

Just ask copilot to look at all of the files in your solution and suggest potential performance improvements.

To be honest, I would not expect any useful feedback from a question...

Trying to optimize something just because is like trying to skate uphill into a blizzard.

As Brent Ozar keeps reminding us ... "What problem are you trying to solve?"

Every optimization comes...

Without data to test, maybe this will do the trick

SELECT    f.INVG_ID
        , MaxAgentSFRDt    ...

SSMS 21 allows you to integrate directly in to GIT.

It looks like a sophisticated plug for their company, with 2 links to their site

A clustered index may appear to retain the sort order.  However, there is zero guarantee that it will always be sorted correctly.

The ONLY way to guarantee sort order is to...

Agreed.  But now I am no longer getting email notifications on threads that I reply to.

Consider a table like this

CREATE TABLE dbo.MyTable (
    ID        int      NOT NULL...

Why add an IDENTITY?  You can use a SEQUENCE object, and set it as the default value for the field.  Then you dont need to change anything else.  You can...

It's a bit long-winded, but this is what I came up with

DECLARE @TestData table (id int, dateVal varchar(12));

INSERT INTO @TestData ( id, dateVal )
VALUES ( 1, '00:02:03:123'...

You need to first cast the string to a format that is recognisable to SQL

Something like this

DECLARE @SourceTable table (ANNOUNCE_DATETIME varchar(50));

INSERT INTO @SourceTable (ANNOUNCE_DATETIME)
VALUES ( '"20180919T201400+0000"' )
...

Try something along these lines ...

WITH cteDiff (
  SELECT  A, C, D, E
  FROM    [Database].dbo.[Table]
  WHERE   B ...

Try something like this

if object_id('tempdb..#temp') is not null
  drop table #temp;
GO
create table #temp
(
    date datetime,
    category varchar(3),
   ...

Be careful with global temp tables.

Multiple SPIDs could end up tripping over each other, as they can all see the global temp table.