I have the following stored procedure. I want to pass HTCode from my VB.Net subroutine and then received the values back in a datatable. Is that possible? If so, could someone help me out with the code?
ALTER PROCEDURE dbo.HospBillingCodeLoop ( @HTCode varchar(50) )AS SELECT * FROM [Hospital Billing Data SQL] WHERE HTCode = @HTCode RETURN