#Cross join misol

create table TargetEmployee(
EmployeeID int ,
EmployeeName nvarchar(200),
Salary int,
Ispermanent int
)
insert into TargetEmployee([EmployeeID],[EmployeeName],[Salary],[Ispermanent])
values (1,'David',200,0),
(2,'tim',200,0),
(3,'marry',200,0),
(4,'Kevin',200,0)

create table Targetsourse(
EmployeeID int ,
EmployeeName nvarchar(200),
Salary int,
Ispermanent int
)

insert into Targetsourse([EmployeeID],[EmployeeName],[Salary],[Ispermanent])
values (1,'David',500,0),
(2,'tim',500,0),
(5,'alice',500,0),
(6,'cook',200,0)

select * from TargetEmployee

select * from Targetsourse

merge TargetEmployee as target
using Targetsourse as source
on source.EmployeeID=target.EmployeeID

when not matched by target then
insert (EmployeeID,EmployeeName,Salary, Ispermanent)
values(source.EmployeeID,source.EmployeeName,source.Salary,source.Ispermanent)

when matched then update set
target.Salary=source.Salary,
target.Ispermanent=source.Ispermanent

when not matched by source then
delete;

--------Burhon Baqoyev, [7/15/2022 5:38 AM]
SELECT empid, DATEADD(dd, N, '2016-12-06') AS [DAY]
FROM HR.Employees CROSS JOIN Nums
WHERE n BETWEEN 0 AND 4
ORDER BY empid;

------Burhon Baqoyev, [7/15/2022 5:39 AM]
SELECT empid,
DATEADD(DAY, n, '2016-06-11') as dt
FROM HR.Employees,
(
SELECT TOP 5 n
FROM dbo.Nums
) as ndbo
ORDER BY empid

Loyihani to'liq tugatish vazifasi junior dasturchilarga berilganda 😂

👉 @Dasturlash_hayoti

Rank va DensRank