Yes, it is the same locally too. I researched. There is no much resource about this. Thanks though.

• This reply was modified 5 years ago by  Kenean.

It doesn't work that way too.

Definitely, there would have been some change; I meant, no intentionally introduced changed. What would it be? How can I fix this? Any guidance is much appreciated!

@bmg002, this has indeed boosted the performance. Thanks. I was trying to consider Luis's recommendation as it would make it even faster. But couldn't incorporate the 3rd table.

@luis Cazares thanks! There was a third table 'Billing' though. I have tried to follow the same logic to include that in your code, but it is displaying...

• This reply was modified 5 years, 2 months ago by  Kenean.

Thank you Ben and ScottPletcher! In order to tune the query, I was considering to change the subquery to a join. However, in addition to the one Scott suggested, I...

• This reply was modified 5 years, 2 months ago by  Kenean.

@Phil, I've provided the DDL and sample data. How can I do it in a single statement? Won't separating the transactions help? Thanks.

John, thanks.  
About your Q: the dynamic SQL is needed as the changedateutc is retrived from clients' databases. The clients have specific domains.

Jeff, thanks for the interesting takeaway about STR(). For your question about why I need to convert the decimal(9,2) column to FLOAT, it is because of the data conversion error....

I meant a single record (a single row record of a specific column)

Thank you all! FYI ~ someone also suggested this along with the description: 
COALESCE(STR(columnname),'')
'Numeric types can NEVER be blank. They either have a value, or they're NULL. "Blank"...