How to get duplicate on Part Id and Company Id both and have different Status ?
I work on SQL server 2012 I have issue I can't get duplicate on company id and part id
and on same time have different status
as partid 1211 and companyid 3030 repeated two times meaning two rows but with different status
pending and Done
so How to write query do that
create table #PartsData ( PartId int, CompanyId int, Status nvarchar(50) ) insert into #PartsData(PartId,CompanyId,Status) values (1211,3030,'Pending'), (1211,3030,'Done'), (1599,4812,'NotFound'), (1599,4812,'Pending'), (9731,4050,'Inprogress'), (9731,4050,'Done'), (7801,4031,'Pending'), (7822,9815,'Pending') Expected result : PartId CompanyId Status 1211 3030 Pending 1211 3030 Done 1599 4812 NotFound 1599 4812 Pending 9731 4050 Inprogress 9731 4050 Done