Complex Update Logic

this?

UPDATE t1
SET SizeID = t2.SizeID
FROM T1 t1
INNER JOIN T2 t2
ON t2.Description LIKE t1.OS + ' %'
AND (t1.CPU BETWEEN t2.MinCPU and t2.MaxCPU
OR (t1.CPU >= t2.MinCPU AND t2.MaxCPU IS NULL))
AND (t1.Memory BETWEEN t2.MinMem and t2.MaxMem
OR (t1.CPU >= t2.MinMem AND t2.MaxMem IS NULL))

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page