It says "Executing Query..."

It took 3 hours and 08 minutes to finish, Can this happen since it has to update big number of records...?

It says "Executing Query..."

It took 3 hours and 08 minutes to finish, Can this happen since it has to update big number of records...?

Thanks all.. I did this using temp table and a curser its working fine.

Further I'm using SQL agent to execute this as a JOB and it sends alerts when certain...

a

b

Thanks KK, but above query will return multiple rows group by machine name...

yeah I can simplify.. but number of machines can be vary..

I know there are some clean and...

regarding performance...

I ran both queries on my table.

Ramesh query runs around 01 min +/- seconds

VIC-K query runs around 03min and 40 +/- seconds

must consider about performance..!

thankx..

Thank you, this your query is simple, clear and nice..