declare @Pipno table(V_3 varchar(500),V_2 varchar(10))
insert into @Pipno (V_3)
Select COUNT(IMEINo)
FROM Jobsheet
WHERE (ModCode ='H057') AND (ServiceCentreCd ='C009')
GROUP BY IMEINo,ModCode
HAVING (COUNT(IMEINo)> 1)
update @Pipno set V_2=1
Select * from @Pipno
No comments:
Post a Comment