Recordset from SQL Server stored procedure that needs parameters

I would be grateful for any examples (however simple) that use Delphi
to get a recordset back from an SQL Server stored proedure that needs
parameters passed to it.

Thanks in advance,
Kelly.