Hi,

Im just learning to produce reports from sql stored procedures. I have done some basic ones using SELECT statements etc. I know want to look at putting parameters in the stored procedures and cant find any literature to help me.

1. Can you use a pick list in stored procedures, like you can when using parameters in Crystal? and can anybody provide an example

2. Can you prompt the user for a value in stored procedures, ie, for example the user is asked What month are you looking for and they then type in May as an answer? again can anybody provide an example

3. Can you pass a WHERE clause through a stored procedure, i.e hardcode it in, i,e, WHERE month = 'May' for instance and can you provide me with an example

4. Also are there any good webpages where you can learn more about stored procedures

Thanks

Mark

markw,

Can't believe 90 read this post and didn't contribute anything. Here's a good link to get you started on Sproc:

http://www.4guysfromrolla.com/webtech/111499-1.shtml

HtH.