Now all everyone has to do is fix the links in their signature line. Well… that and a dozen other things. ...

+100 Salomon,

didn't see your post earlier

😎

My stored procedure is running fast (2 sec) for particular parameter in local server with 25 million rows in the table, but on the testing server, it takes 15...

Here is one link that is not working, https://www.sqlservercentral.com/articles/SQL+Server+2012/106903/

and another one, https://www.sqlservercentral.com/questions/functions/178188/

😎

Most of the links I've tried from the discussions to the Question Of the Day are not working either

Happy birthday Jonathan!

Check the function from this article
😎

The function (slightly modified)

CREATE FUNCTION [dbo].[DelimitedSplit8K_LEAD]
--===== Define I/O parameters
   (@pString VARCHAR(8000),...

This should get you started
😎

USE TEEST;
GO
SET NOCOUNT ON;

DECLARE @ItemNumber Table
(
PONumber varchar(10)
, ItemNumber varchar(10)