I used this article:
http://blogs.msdn.com/infopath/archive/2006/12/20/using-sql-server-2005-web-serv
ices-with-infopath.aspx
and the appendix in Professional InfoPath forms to create a web service for
a web based Infopath form.

My stored procedure works when I execute it on the server, but when I call
it from the web service in InfoPath, the rowset is empty.  I've been
searching all day for a solution - anyone have any insight into what I'm
doing wrong?

Here's the code:
CREATE ENDPOINT get_Orders
STATE=STARTED
AS HTTP(
SITE = 'server',
PATH = '/sql/demo',
AUTHENTICATION = ( INTEGRATED ),
PORTS = ( CLEAR )
)
FOR SOAP (
WEBMETHOD
'http://server:12345/'.'Order'
(NAME='SamplesOrderForm.dbo.GetOrderandDetails2'),
BATCHES = ENABLED,
WSDL = DEFAULT
)

GetOrderandDetails2:
    @SampleID Int
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
SET TRANSACTION ISOLATION LEVEL READ COMMITTED

   -- Insert statements for procedure here
SELECT    
Orders.Department,
Orders.Requestor,
Orders.DeliveryDate,
Orders.Carrier,
Orders.PickUpLoc,
Orders.Contact,
Orders.ContactPhone,
Orders.DeliverHrs,
Orders.DeliverNotes,
Orders.Truck,
Orders.Comments,
Orders.PickupDate,
Orders.CarrierContact,
Orders.CarrierPhone,
OrderDetails.DetailID,
OrderDetails.Sku,
OrderDetails.Item,
OrderDetails.Qty,                    
OrderDetails.Pallet,
OrderDetails.LotCode
FROM         Orders, OrderDetails
WHERE     Orders.SampleID = @SampleID AND OrderDetails.SampleID =@SampleID
END

THANK YOU IN ADVANCE!!!