Parameters and Stored Procedures

[spiego]

I have a stored procedure that I am using to create a report. At the end of the stored procedure I have the following select statement (rptset is a temporary table created in the proc):

select * from @rptset
      where
      rordered!=rshipped

If I want to use parameters from the report to filter the data from the stored procedure, how would I do that?

 

[xlbo]

filter data in report once all data has been returned or filter as part of the query to restrict the data returned in teh 1st place?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question