• i declared initially

    Declare @Rank as varchar(2000)

    set @Rank=null

    then

    Sp'Query

    but passing the values is from table.

    thanks & regards