Phil,

Per your advice I have made the following revisions. Is this accurate?

 

SET XACT_ABORT ON;


BEGIN TRY

BEGIN TRANSACTION;

/*This routine sets any SOAP Note where there is no matched claims...

I made the below change to my code in access (added single quotes around parameters) and it worked.

Thanks Drew you were right I needed to submit all three parameters

 

            
July 19, 2019 at 8:54 pm
            
#3664662

            
            
                                                
        

Hi Drew,

In my where clause I have it accepting @TIN or @ParentGroupName is this the correct way to handle this?

WHERE ((T1.[TIN] = @TIN OR T1.[PARENT_GROUP_NAME] = @ParentGroupName)...

Thank you very much.....

Thank you so much that worked like a charm... Also, I will make sure to use the correct format in future posts.

If the invoice only contains HCC=12 then return 12 if the invoice contains HCC 12 and 13 then 12 trumps 13 so return 12. Basically if the invoice only contains...

Thank you very much....

Thanks stewartc this helps....

Ok, thanks for the response..

Brian