Saturday, March 30, 2013

how to Add Multiple Value in a Variable In SQL Server


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