TY Phil that git me to the finish line

the three fields are datetime and I'd like to drop time

convert(date,coalesce(completeddate,lastsaveddate,receiveddate),' ') [infoDate],

Msg 8116, Level 16, State 1, Line 47

Argument data type varchar is invalid for argument 3 of convert function.

Was struggling with how to drop the...

Thanks for offering a solution Steve, so the challenge for me is converting the code into a workable solution

You added a field RowNum as part of the temp...

Have a new challenge I'm afraid b/c I need (2) case statements and those values must be in the GROUP BY, I'm ending up with repeating account values that correspond...

TY for the quick response

WAs able to figure this one out had a problem in the temp table subquery logic which was not returning all instances of most current exchange rate by currency type.

Here...

Sorry for the confusion, I added in account_id =464 in the where clause to limit the output since the data set is pretty large, figured if I could solve for...