CREATE Table #Temp
(
Ind INT IDENTITY(1,1),
EmpID VARCHAR(50),
DOJ DATE,
SAL INT,
Nationality VARCHAR(50)
)
DECLARE @MinIdt INT, @MaxIdt INT
INSERT INTO #Temp SELECT EMPID,DOJ,SAL FROM EMP --------- FOR SOME CONDITION
DECLARE @MinIdt INT
DECLARE @MaxIdt INT
SELECT @MinIdt = MIN(IDT), @MaxIdt = MAX(IDT) FROM #Temp
WHILE @MinIdt <= @MaxIdt
BEGIN
-- Check 1st Condition
--IF EXISTS
--CHECK 2nd Condition
-- IF True 3rd Condition
--THEN
-- check Nationality for lets say Indian 4th Condition
--Update Emp table with condition
-- Update one more log table
--else
--check for lets say NRI
END