Loading

get value from stored procedure

Devendra Kumar

10y1.1k.NET

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pradip Pandey10y ago
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.
0
Saillesh Pawar10y ago
Kindly check the product name you are passing as parameter and request you to please be more specific what you are trying to ask.
0