Posted by Jack Vamvas on 03/21/07 19:44

Try:

where Product_Sales.Order_Amount =
CASE
when @p1 is null then Product_Sales.Order_Amount
else @p
END


--

Jack Vamvas
___________________________________
Advertise your IT vacancies for free at - http://www.ITjobfeed.com



"knowzero" <isacp@bhphoto.com> wrote in message
news:1174504953.877881.232990@b75g2000hsg.googlegroups.com...
> my query:
> select Product_List.*, Product_Sales.*
> from Product_List
> left outer join Product_Sales on Product_List.ID = Product_Sales.ID
>
> this works fine. its simple. I have this in a report and I would like
> to add a parameter @p1 to add to the query
>
> where Product_Sales.Order_Amount >= @p1
>
> my problem is that if @p1 is null I want to retrieve all recorders in
> Product_List. any ideas.
>
> Do you need more clarification.
>

• Next in forum: Re: Table name starting with prefix tbl
• Prev in forum: help with parameter in WHERE
• Thread view: Re: help with parameter in WHERE

[Reply to this message]