Query Optimization

Your query:

FROM##tempa

        ,dbo.tbl_cal_db AS h

First, you need to join them. I think that is why it is taking 20 min. Maybe take outside 'from' out and add table 'h' to inside query?

Rgds.