SQL Stored Proc and Dataset

Answer 1

Does your stored procedure start with SET NOCOUNT ON? The lack of this can sometimes cause issues if the stored procedure is processing multiple queries before the final SELECT.

Answer 2

Got it.. if you take a look at my parameters up top I am accidentally assigning transaction to customer and customer to transaction. DOH!

Thanks, Mike