New 2005 Syntax With - Update Not Working

I have tried the following, the update part i snot working. Any idea why? 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

Update FeaturedClassifiedsSET FeaturedDisplayedCount = FeaturedDisplayedCount+1

Where

Row between

@startRowIndex And @startRowIndex+@NumRows-1

END

 

 I have tried function too for this, but function can not update table I guess.... Can I call stored procedure for each column? How?

 I thought the code above would work? What am I missing?