get value from stored procedure

Question

hi frnd

 

 

i select product name from database

 

and in my database product name same but according to size price are different so when select product name then it select always first product id and there details  

 

sp use

@productname 

 

 

select productid from products master where productname=@productname