Hi Jeff, Thanks your note. I have added one more column and it is working now.

Hi,

Below is my Query.

SELECT

EmpID,

HeaderID,

Status,

Time

FROM

<TableName>

WHERE

EmpID = '1'

AND Status = 'PENDING'

AND ROW_ID <= ISNULL( (

SELECT

ROW_ID

FROM

(

SELECT

ROW_NUMBER() over(partition by EmpID

ORDER BY

ROW_ID) AS Sl_No,

ROW_ID

FROM

<TableName>

WHERE

EmpID = '1'

AND HeaderID = '123'

AND Status = 'FIXED'

)

A

WHERE

A.Sl_No = 2),

(

SELECT

MAX(ROW_ID)

FROM

<TableName>

WHERE

EmpID =...

Hi Ells,

Yes, you're correct I'm trying to correct within SSIS. The data is already in staging tables and there is a function which will return us the string...

Yes mistakenly posted. Sorry about that, please.

Hi,

What are all the possible delimiters?
Delimiters are dot, coma, underscore and space

Could you explain the logic behind the final 2 rows?
First 4...