I work on sql server 2012 . I face issue I can't generate unique Id from merge or concave both columns
Search Parts and Company ID and generated Id must be on column Generated ID
to be easier and fast on search
so Please How to generate unique Id from both column Search Parts and Company ID and if both column repeated value both get same Id so please How to do that
AS Example
SearchParts CompanyId GeneratedId A5ghf7598f7GGHYUTYA 3456 901 when concate both columns Search Parts and Company Id generate Id and take same Id in case of repeated but main idea generate number unique for both column search parts and company id