i applicate your remarks but i raise the following error

The NEXT VALUE FOR function cannot be used directly in a statement that contains an ORDER BY clause...

• This reply was modified 1 year, 11 months ago by phine.

i take all your remarks and it's working and it's works . thanks

CREATE OR ALTER PROCEDURE dbo.XXX_RestoreTryenreFromGeusa_VISUAL (@DateParam DATE = NULL)
AS
/********************************************************************************************************************************************/
/*    The purpose of...