This procedure works great.

But how can I include more parameters.

Does adding more parameters would make the query more complex.

Create Procedure Usp_OrderDetails

(@ItemName varchar(20)=null,

@ItemGroup varchar(20)=null,

@ItemPrice money = null

)

As

Select M.OrderID,M.CustName,

(select...

That query worked, but only for search parameters having entries in the order item table.As per the query, the Join statement, would always looks for matching entries in the orderitems...

Tried the followin query based on your reply.

------------------

select orderid, custname, orderdate, isnull(qty, 0) as qty

from dbo.orders

left outer join

(select orderid as qtyorderid, count(*) as qty

from dbo.orderitems

...

The Problem is resolved. I am now using EXEC(sql1+sql2) instead of sp_executesql. I have changed the logic such that I need not require any of the returning parameters that needs to be...

Thanks for your response. It was helpful.

However, as indicated, the XML file needs to be programatically loaded from its folder path. This procedure would be scheduler based, and would be...