SQL update using range in another table : I Have two table 

    **T1**		
    
    object	Value	Calculated_Name 
    
    AA	     10	
    BB	     100	
    CC	     150	
    
    **T2**	
    	
    R1	R2	   Name
    
    1	15	    Z
    16	130	    w

I Want UPDATE T1.Calculated_Name  with T2.name like this 



    **T1**		
    
    object	Value	Calculated_Name 
    
    AA	     10	       Z
    BB	     100	   W
    CC	     150	  Null

How I can do this
PS: I have to run the command on SQL2000 or higher

    
   





