Viewing 15 posts - 1 through 15 (of 279 total)
Thanks working.
May 17, 2022 at 7:32 pm
Still same issue. Is it how you pass environment varibles correctly? I just specified folder name ? do we need to give path sepcifically?
May 17, 2022 at 2:34 pm
Thank you. I was able to update my logic based on the query you provided. Is there a way in your query to get the relationship for those i gave...
January 24, 2022 at 11:24 pm
Thanks for the Reply. I was able to validate data using Regular expressions , since we have oracle source data Using Script component as transformation in SSIS. It is way...
October 8, 2021 at 4:34 pm
Thank you everyone for the reply.
July 19, 2019 at 4:36 pm
;WITH CTE AS (
SELECT E.E_ID , E.D_ID, E.salary,Row_number() over (partition by d_id order by salary desc) as row
FROM Employee2 E
)
SELECT CurrentRow.E_ID , CurrentRow.D_ID , Nextrow.Salary as othersalary
from CTE CurrentRow
left JOIn...
July 18, 2019 at 9:34 pm
Here is how i am looking for status to be in second table. If there is no entry in table 1 for a loan Then i need status to be...
June 19, 2019 at 9:11 pm
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...
June 19, 2019 at 8:44 pm
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;
June 19, 2019 at 8:26 pm
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...
June 19, 2019 at 8:24 pm
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','','')
June 19, 2019 at 6:33 pm
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...
May 8, 2019 at 6:07 pm
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...
May 8, 2019 at 4:32 pm
Viewing 15 posts - 1 through 15 (of 279 total)