I just provided two loans but if i take 1000 loans, i do not want same value for status1 , status 2 . instead i want to get different status...

SELECT ls.LOANNUMBER
,Status1 = MAX(COALESCE(
NULLIF(ls.CLOSED, '')
,NULLIF(ls.Pending_Transfer, '')
,NULLIF(ls.REO, '')
,NULLIF(ls.Foreclosure, '')
)
)
,Status2 = MAX(COALESCE(
NULLIF(ls.CLOSED, '')
,NULLIF(ls.Pending_Transfer, '')
,NULLIF(ls.REO, '')
,NULLIF(ls.Foreclosure, '')
)
)
FROM #LoanStatus ls
GROUP BY ls.LOANNUMBER;

• This reply was modified 5 years, 6 months ago by  Steve Jones - SSC Editor. Reason: format code

Your code works , if you place the columns as you want to see result ( as example i provided) , but if i place all the columns in same...

CREATE TABLE #LoanStatus

(

LOANNUMBER INT

,CLOSED Varchar(200)

,Pending_Transfer Varchar(200)

,REO Varchar(200)

,Foreclosure Varchar(200)

)

INSERT INTO #LoanStatus ( LOANNUMBER, CLOSED ,Pending_Transfer,REO,Foreclosure ) VALUES (12345,'','Pending_Transfer','','Foreclosure')

INSERT INTO #LoanStatus ( LOANNUMBER, CLOSED ,Pending_Transfer,REO,Foreclosure ) VALUES (12678,'Closed','Pending_Transfer','','')

JUST FYI. This sql  was just  an example i provided to explain others , who is indeed trying to help me. I am not really at this moment concentrating on...

• This reply was modified 5 years, 7 months ago by  komal145.
• This reply was modified 5 years, 7 months ago by  komal145.

just FYI. I just edited my post with the dates and tried to explain more about the "Expirationdate" computed column. I dont know why i cannot see my reply to...

sometimes two or more steps come into table on same day. As we load data from files. So the above query does not work. 🙁

Lynn- My view is the same as yours. But question was if i have the package with such three different dataflow tasks , how you design it to schedule. I...