I run the query below for only 100 records and it runs for 5 mins plus. I had to cancel. When I run the Select without ca.HDDSUM AS TOTHDD...

Your query is only referencing @introwno ones instead of referencing all rows in the staging table without having to loop through each row.

Thanks, Kraig,

I'll test the query and get back with you soon.

Sam :discuss:

I'm quite sure the sub-selects are slowing execution. I'll replace them with the joins and let you know how it goes.

Thanks, Craig I'll try out this statement and let you know how it goes.