Hi RPA,
Refer the below query.
DECLARE @TblFirst AS TABLE (Id INT,Name VARCHAR(10))
INSERT INTO @TblFirst VALUES(1,'Amonullo')
INSERT INTO @TblFirst VALUES(2,'Samandar')
INSERT INTO @TblFirst VALUES(5,'Asror')
DECLARE @TblSecond AS TABLE (Id INT,Name VARCHAR(10))
INSERT INTO @TblSecond VALUES(3,'Firuz')
INSERT INTO @TblSecond VALUES(4,'Bahrullo')
INSERT INTO @TblSecond VALUES(6,'Sadriddin')
DECLARE @idFirst INT, @idSecond INT, @newId INT
SELECT @idFirst = MAX(Id) FROM @TblFirst
SELECT @idSecond = MAX(Id) FROM @TblSecond
IF ISNULL(@idFirst,0) = 0 AND ISNULL(@idSecond,0) = 0
BEGIN
SET @newId = 1
SELECT @newId
END
ELSE IF (ISNULL(@idFirst,0) < ISNULL(@idSecond,0))
BEGIN
SET @newId = @idSecond + 1
INSERT INTO @TblFirst(Id, Name) VALUES (@newId, 'Firuz')
END
ELSE IF (ISNULL(@idFirst,0) > ISNULL(@idSecond,0))
BEGIN
SET @newId = @idFirst + 1
INSERT INTO @TblSecond(Id, Name) VALUES (@newId, 'Firuz')
END
SELECT * FROM @TblFirst
SELECT * FROM @TblSecond
Output
TblFirst
Id |
Name |
1 |
Amonullo |
2 |
Samandar |
5 |
Asror |
7 |
Firuz |
TblSecond
Id |
Name |
3 |
Firuz |
4 |
Bahrullo |
6 |
Sadriddin |