Declare@numint set@num=0 while(@num<9) begin set@num=@num+1 ifnotexists(Select Attrid FROM HVC_Statistics_Setting WHERE Attrid =@num) begin INSERTINTO HVC_Statistics_Setting(PortalID,AttrID,AttrName,StringValue,FloatValue) VALUES (@PortalID,@num,'','',Case When@num=1then@TotalAccessed When@num=2then@AllArticlesNum When@num=3then@AllArticleHits When@num=4then@MonthTotalUpdated When@num=5then@MonthArticleHits When@num=6then@WeekArticleUpdated When@num=7then@WeekArticleHits When@num=8then@Score end) end else begin Update HVC_Statistics_Setting SET PortalID=@PortalID, AttrID=@num, AttrName='', StringValue='', FloatValue=Case When@num=1then@TotalAccessed When@num=2then@AllArticlesNum When@num=3then@AllArticleHits When@num=4then@MonthTotalUpdated When@num=5then@MonthArticleHits When@num=6then@WeekArticleUpdated When@num=7then@WeekArticleHits When@num=8then@Score end where Attrid =@num end end