Pass variables to stored procedure

[learner45]

Hi,

I would like to run a stored procedure on a table of products (tblProducts). Basically the SP needs to:

1. Get the min. 'Cost' for each of the given four products (ProdID = 1, 2, 3, 4)
2. Order the results in Ascending.

Thanks for your help!

 

[SQLScholar]

Firstly - you havent said what variables you want to pass.

Then can you also give an example of what the output would look like?

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[learner45]

Hi SQLScholar,

Thanks for helping. With variabls I meant the SP should look for the minimum of each of the following given PruductID's i.e.

ProductID =1
ProductID =2
ProductID =3
ProductID =4

I'm interested in finding out the min. 'cost' of only these products from a list of couple of hundered products.

The output will look like this (ordered according to cost asc):

ProductID Supplier Cost
3 IBM 100.34
2 Epson 134.34
4 Canon 138.37
1 Dell 150.56

Thanks!

 

[SQLScholar]

Ok.

Is can the product be supplied by multiple suppliers?

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[SQLScholar]

Ok. One other question

Is this for a project your doing (school\uni\college etc) or a real life thing? Not that i wont help for a uni\college thing, just my answer will be different.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[learner45]

The productId-Supplier combination is not unique; i.e. there can be multiple suppliers for a given product.

This is an exercise for school...

 

[drlex]

combination? So there's a Supplier table too? Why not just type in the entire exercise in the first post?

soi là, soi carré

 

[SQLScholar]

Ok then if its for school i will point you in the right direction. Split it up into pieces.

The first thing you need to do is to be able to find out minimum cost per product. You should be able to do this using MIN and group by.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[SQLScholar]

When you have worked that bit out - post some code.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------