Passing Parameters To Nested Parameter Queries

Though I am a novice to MS SQL server (2000 I believe), I can do almost!
everything I need. Maybe not efficiently, but usefully. However, I have
a problem -- a complex query problem...

I can create a parameter query in a stored procedure, but how do I use
the result set of a parameter query in a select query (in the same or
another sp)? In short, if a select query contains a result table that is
generated as a parameter query, how do I pass the parameter through the
select query to the nested parameter query?

For example, if I have a sp parameter query called [e_typerows], I could
write the following select query which uses the (single) result set from
[e_typerows] plus other tables or views:

SELECT TOP 100 PERCENT bi_occ_01_e.row, bi_occ_01_e.pos,
bi_dictionary_e.typestring, bi_occ_01_e.shadow
FROM bi_dictionary_e INNER JOIN
(bi_occ_01_e INNER JOIN
[e_typerows] ON bi_occ_01_e.row = [e_typerows].row) ON
bi_dictionary_e.typeid = bi_occ_01_e.typeid
ORDER BY bi_occ_01_e.row, bi_occ_01_e.pos

Even though [e_typerows] is a (storted procedure) parameter query this
will work IF my parameter in [e_typerows] has a default, say "yyyy". In
the default case no parameter needs passing. But what if it doesn't have
a default value or if I need to pass a parameter to it?

Is there any way to replace[e_typerows]in the above query with something
like [e_typerows @myparameter='xxxx']? (Maybe I should try that! I've
seen nothing about it though.)

My parameter query, [e_typerows], looks like this in fact:

@typestringparameter varchar(100) = "yyyy"

SELECT dbo.bi_dictionary_e.typestring, dbo.bi_occ_01_e.row
FROM dbo.bi_occ_01_e INNER JOIN
dbo.bi_dictionary_e ON
dbo.bi_occ_01_e.typeid = dbo.bi_dictionary_e.typeid
GROUP BY dbo.bi_dictionary_e.typestring,
dbo.bi_occ_01_e.row
HAVING (dbo.bi_dictionary_e.typestring = @typestringparameter)

Any suggestions would be greatly appreciated! (For the moment, I first
generate the parameter query result set, then I loop through each row of
that result set and do a select query with that row as a parameter --
very complicated!, though it does work.)