Thanks Guyz

I connected it one more time with itself and used the MAX function, which kind of solved my problem.

I know this is not an ideal thing to do

SELECT

...

I took out the distinct.

If somebody else could also look into it that would be great

Thanks Sean, what would be the correct statement, Im using this.

(SELECT MAX(COUNT(C.AppID) WHERE C.Status = 'Funded')

Can we do MAX on aggregates?

Facilitator is text field, that's why subquery not a JOIN

Thanks, I am using the following in the select statement but getting an error:

COALESCE (CONVERT(varchar(20),TBS.[DateTime], 101), CONVERT(varchar(100),TBS1.[DateTime], 101), CONVERT(varchar(20),APL.DateAppEntryStart, 101) AS [Checking]

Msg 156, Level 15, State 1, Line 23

Incorrect syntax...

Thank you guyz!!

user does not have a option for selection, they can only type it in.

Can anyone make sense of what exactly is happening with the tables(loan, usr_m1_letter_requests, m1lettersque)?

Thanks Luis,

Even the following is taking endless amount of time, I kill it after 3-4 minutes, I am trying to see if there are any repetitions which we can avoid,...

I am not a fan of cursors, never used it. Is there a way we can write the code without it? Any help would be appreciated.

It is very odd. thanks for your help guyz

I inherited a bad code, I am getting a deadlock when I am using your where clause

Is it because of the performance issue I shouldn't be using it in the where clause:

WHERE CONVERT(varchar(10), a.DateAppReceived, 101) = CONVERT(varchar(10), GETDATE(), 101)

this actually did the job for me.

DATETIME

SELECT STATEMENT

, CONVERT(varchar(10), a.DateAppReceived, 101) AS DateAppReceived

CREATE TABLE [dbo].[M1CustLetters](

[LoanID] [nvarchar](10) NOT NULL,

[StatementDate] [datetime] NOT NULL,

[CustomerName] [varchar](40) NOT NULL,

[Address1] [varchar](40) NOT NULL,

[Address2] [varchar](40) NOT NULL,

[BankPool] [varchar](12) NOT NULL,

[AcctNum] [varchar](12) NOT NULL,

[DueDate] [datetime] NOT NULL,

[NextStatementDate] [datetime] NOT NULL,

[CurrentBalance]...