I have table there is a status column when status is active

Try this:

 DECLARE @TIME_FROM_TABLE  DATETIME
 
 SET @TIME_FROM_TABLE = (
 SELECT UDT_TS AS TIMESTAMP
  FROM TSTATUS 
  WHERE CNY_CD = 'US'
 )


 IF ((GETDATE()- @TIME_FROM_TABLE) > 0)

 BEGIN
 --SET THE STATUS COLUMN TO INACTIVE
 --DO INSERT OPERATION
 END
 ELSE

 BEGIN 
   --SET THE STATUS COLUMN TO ACTIVE
 END

Hi,

Question is not clear. Please give some more detail.