This should work for you....

select Customer, status, sum(datediff(dd, createddate, lastupdatedate))

from #TempTable

group by Customer, status

order by customer

Check out this....

update table1

set col2=B.col2

from table1 A, table2 B

Where A.col1 = B.col1 and A.col3>=B.col4 and A.col3<=B.col5

SKC

You can get the requested resultset in many ways.. here is one simple way...

Select Distinct TBL_1.EmpID, TBL_1.Name, TBL_2.UpdateTime from EmpMst TBL_1 With (Nolock)

Left Outer Join EmpMst TBL_2 With (Nolock) On...

Check your code may be in test mode it is closing connection to the database after certain point. In VB once the connection is open it will remain open until...

Please post the cursor query to help you better.

SKC