Customer is experimenting with %vid variable for selecting row numbering for sql queries. Basically he's trying to implement paging functionality.
He is confused that select %vid from (select ...)
returns dummy number whilst select *,%vid from (select...)
returns correct data.