>CREATE PROCEDURE Cusdetails @cCustomerID nchar(5) AS >SELECT Customers.CustomerID, ContactName, CompanyName, > Orders.OrderID, OrderDate >FROM Customers, Orders >WHERE Customers.CustomerID = Orders.CustomerID >AND Customers.CustomerID = @cCustomerID >ORDER BY Orders.OrderID >FOR XML AUTO >GO > > >lnHandle = ... >m.customerID = 'BONAP' >SQLExec(lnHandle, 'Exec CusDetails ?customerID','SPResult') >Returns just one row with one field.