You've already got the pseudo code for these which is a good start.
My first question is, is the stored procedure the best place for doing this - would it be better placed in the application?
Otherwise it is a case of writing a few "if"s e.g.
IF @age > 9
BEGIN
IF @paidamt = 200
BEGIN
SELECT
1
-- process for age at least 10 and 200 paid
END
ELSE
BEGIN
RAISERROR ('Incorrect parameters',10,1)
END
END
and so on.
Good luck
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx