Using a sub-query instead of a variable in STIntersection?

Arnon

I'm executing the query bellow to intersect a soil layer with a polygon (a parcel) with no problem.
I would like to replace the @parcel in the select statement with something like a sub-query. I was naive to think that putting a SELECT Shape from another layer would do the trick, but it fails.
Any ideas?
Thanks, Arnon

DECLARE @parcel geometry 
        =geometry::STGeomFromText('POLYGON ((170018 1068876, <more coordinates>))',1);
SELECT Shape.STIntersection(@parcel)
FROM soils
WHERE Shape.STIntersects(@parcel)=1

Arnon

Eventually I abandoned (for now) the subquery idea. Instead I'm using a join with STIntersects in the join criteria. This makes the shapes of both layers available for intersection.
Basic, I guess...