Re: Regarding query execution for long time

2019-01-28 Thread Durgamahesh Manne
On Mon, Jan 28, 2019 at 8:41 PM Adrian Klaver wrote: > On 1/28/19 5:04 AM, Ron wrote: > > On 1/28/19 6:20 AM, Durgamahesh Manne wrote: > >> Hi > >> > >> below query is being executed for long time > >> > >> Select > >> distinct ltrim(rtrim(ssnumber)), CL.iInsightClientId, > >> ltrim(rtrim(TFA.cli

Re: Regarding query execution for long time

2019-01-28 Thread Adrian Klaver
On 1/28/19 4:20 AM, Durgamahesh Manne wrote: Hi below query is being executed for long time Select distinct ltrim(rtrim(ssnumber)), CL.iInsightClientId, ltrim(rtrim(TFA.client_account_key)) as vchAccountNumber, concat(TFA.first_name, ' ', TFA.last_name) as vchAccountName, concat('AP:TIAA', TF

Re: Regarding query execution for long time

2019-01-28 Thread Adrian Klaver
On 1/28/19 5:04 AM, Ron wrote: On 1/28/19 6:20 AM, Durgamahesh Manne wrote: Hi below query is being executed for long time Select distinct ltrim(rtrim(ssnumber)), CL.iInsightClientId, ltrim(rtrim(TFA.client_account_key)) as vchAccountNumber, concat(TFA.first_name, ' ', TFA.last_name) as vchA

Re: Regarding query execution for long time

2019-01-28 Thread Ron
On 1/28/19 8:10 AM, Durgamahesh Manne wrote: On Mon, Jan 28, 2019 at 6:34 PM Ron > wrote: On 1/28/19 6:20 AM, Durgamahesh Manne wrote: > Hi > > below query is being executed for long time > > Select > distinct ltrim(rtrim(ssnumber)),

Re: Regarding query execution for long time

2019-01-28 Thread Durgamahesh Manne
On Mon, Jan 28, 2019 at 6:34 PM Ron wrote: > On 1/28/19 6:20 AM, Durgamahesh Manne wrote: > > Hi > > > > below query is being executed for long time > > > > Select > > distinct ltrim(rtrim(ssnumber)), CL.iInsightClientId, > > ltrim(rtrim(TFA.client_account_key)) as vchAccountNumber, > > concat(TF

Re: Regarding query execution for long time

2019-01-28 Thread Ron
On 1/28/19 6:20 AM, Durgamahesh Manne wrote: Hi below query is being executed for long time Select distinct ltrim(rtrim(ssnumber)), CL.iInsightClientId, ltrim(rtrim(TFA.client_account_key)) as vchAccountNumber, concat(TFA.first_name, ' ', TFA.last_name) as vchAccountName, concat('AP:TIAA', TF

Regarding query execution for long time

2019-01-28 Thread Durgamahesh Manne
Hi below query is being executed for long time Select distinct ltrim(rtrim(ssnumber)), CL.iInsightClientId, ltrim(rtrim(TFA.client_account_key)) as vchAccountNumber, concat(TFA.first_name, ' ', TFA.last_name) as vchAccountName, concat('AP:TIAA', TFA.routing_number) as vchRepLabel, null as vchOpen