My problem is I don't know where or how to add a parameter for what I need to do. The only parameters that were in there before were for dates and whatnot, the SP was used for reporting purposes so those were entered in the report. I don't know how to add a parameter that will only display results based on user input on the HTML page.

>>>Ok, as long as you have it working...
>>>
>>
>>
>>
>>Not really - too much data is transferred - he needs only a portion of it
>>
>>
>>>Although what if you select into TQuery rather than 'sql' and comment out the select following SQLEXEC statement?
>
>I agree, but I can not understand where exactly the problem lies. Is it just a matter of adding the parameter back to SP to get only relevant data?