update rows in cursor

See more:

SQL

SQL-Server-2012

I want to update the values set in the cursor, inside a while loop, below is my sql query that give error in the statement "

update filteredCommunities
                set SearchStaticCount

"plz help i want to update only cursor values
following is the query

declare @loopCounter int
set @loopCounter=0
Declare @Community as varchar(30)
Declare @Counter as int

Declare filteredCommunities CURSOR FOR 
select SearchStaticCount,Keyword from SearchStatic ss inner join UnitListing us on ss.Keyword=us.UnitListingName  where ServiceTypeId='Sell' and CategoryTypeId='Commercial' 
for update of SearchStaticCount
OPEN filteredCommunities
    FETCH NEXT FROM filteredCommunities INTO @Counter,@Community
	        WHILE(@loopCounter<10)
        BEGIN
		        update filteredCommunities
				set SearchStaticCount=@loopCounter           
 				FETCH NEXT FROM filteredCommunities INTO @Counter,@Community
        END
CLOSE filteredCommunities
DEALLOCATE filteredCommunities