Can I make two update statment on one cte without doing two Cte?

[yosiasz]

Please first respond to answers that other have worked hard to answer for your questions

After add more fields to select statement all records Increased why and how to prevent that?

I work on SQL server 2012 I face issue more records increased after add more columns to select statment as TextUnit and MaxValue why I don't know that I need it to display as two records . Before add textUnit and MaxValue it display two records After add textUnit and MaxValue it display three records . SELECT DISTINCT [InputID],PART_ID,[Vendor ID],Manufacturer,[Digi-Key Part No.] ,[Mfr Part No.],[Description],Category,Family ,Obsolete ,[Non-Stock] , [Part_Status],partNumber,CompanyNam…