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

Pradip Pandey · Answer

Hi Devendra If you have multiple record with same product name but their size and price are different then if you want to get all product name then you have to use group by clause.

Saillesh Pawar · Answer

Kindly check the product name you are passing as parameter and request you to please be more specific what you are trying to ask.