Geting value from select statment to be used in stored procedure

Hi Friends

I've already written a query to retreive specific values from SQL server DB and I want to use that values one by one to be passed in stored procedure

Is that possible?

Thanks,,,