@Joe Celko
I tried LEAD and LAG, but both giving me the same date. See the image, I highlighted one...

@Joe Celko
Joe it's not a homework, do you want entire 2M+ rows of data? I was trying to create the solution...

@Jeff Moden
Yes, I miss-typed <= 5 and > 5

@Jeff Moden
Should be <=5 and >=5

Create table test
(
Caller varchar(20) null,
DT date null,
Call Type varchar(100) null

@Jeff Moden
Yes, thanks

@Jeff Moden

December 18, 2018 at 8:22 am

#2016677

That is the way ERP is setup.

@ Phil
Yes TEST is a schema name not the database
Select  .......... from TEST.tablename

I need to change TEST to PROD when I'm ready to move the SSIS...

Yes, its OLE DB Source, which has a SQL Command. Both Test and Production are on different server. I'm looking for a solution, so when I developed these bunch of...

Sorry, I'm new to SSIS, where is this XML file?

2012

I deleted the OLE Command, rebuild and still the same issue.

Here is the flow

yes

@Lynn, I'm new to all this. What is Set based solution?