Thanks a lot CTEGuy & Chris.

@thom-2 - this is just an example. I wanted to implement this for any tables which has same number of columns and...

Thanks a lot Luis and Thom for the suggestions.

Got it. Thanks all for the explainations.

Hi All,

Thanks for the suggestions. Thanks a lot.
One thing, came into my mind, how can we make this dynamic?? Meaning, if the number of columns...

Thanks Jason for the help.

Tried it myself.

;With MyCTE as(
SELECT account_no, MIN(payment_dt) AS MinPymtDt
FROM LoanPaymentHistory
GROUP BY account_no
)

select
ah.AccountHolderFirstname+' '+AccountHolderLastname as Fullname,
ah.email,
at.AccntTypeDesc,
bb.BranchLocation,

Thanks Arsh.

Hi Jason,

Thanks, I got it.

Thanks a lot for the valuable information RVSC48. Many thanks.

Pl find attach plan. Sort it by actual number of rows in desc order. its an actual execution plan generated in SQL Sentry plan explorer.

NOLOCK is used for peformance sake to avoid blockings. Again, its a business decision and we are just vendors. This is a typical Warehouse system and once data loaded to...

Hi Gail, Any text books that you would suggest on Indexing with worked out examples. I want to keep 1 or 2 books for reading.

Hi Chris,
I tried  to create  those covering indexes  but i  didnt see much  improvement in query performance .  it was 5-10 sec difference. Sometimes the query without indices...