How To Increment Field After Selecting It

I have  FeaturedClassifiedsCount  field, which I would like to update each time record is selected. How do I do it in stored procedure on SQL 2005?

This is my existing code:alter PROCEDURE dbo.SP_FeaturedClassifieds

@PageIndex INT,

@NumRows INT,

@FeaturedClassifiedsCount INT OUTPUT

 

AS

BEGIN

select @FeaturedClassifiedsCount = (Select Count(*) From classifieds_Ads Where AdStatus=100 And Adlevel=50 )

Declare @startRowIndex INT;

Set @startRowIndex = (@PageIndex * @NumRows) + 1;

 

With FeaturedClassifieds as (Select ROW_NUMBER() OVER (Order By FeaturedDisplayedCount * (1-(Weight-1)/100) ASC) as

Row, Id, PreviewImageId, Title, DateCreated, FeaturedDisplayedCountFrom

classifieds_Ads

WhereAdStatus=100 And AdLevel=50

)

 

SelectId, PreviewImageId, Title, DateCreated, FeaturedDisplayedCount

From

FeaturedClassifieds

Where

Row between@startRowIndex And @startRowIndex+@NumRows-1

 

END