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

Question

I have table there is a status column when status is active then data not inserted otherwise insert. status depend on end date if enddate is smaller than the today date then automatically status become unactive and data will be inserted

Hemant Srivastava · Answer

Is your problem resloved?

Hemant Srivastava · Answer

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

Jaganathan Bantheswaran · Answer

Hi Question is not clear. Please give some more detail.