Reading from a SQL Stored Procedure

[radamswindber]

I am able to read from a SQL table using a Database Reader, but I would like to read from the results of a SQL Stored Procedure and put the data into HL7 messages. When I try to do this, there doesn't seem to be anything in the data fields. Is this possible and if it is, is there any guidance on how to do it? Thank you.

[pacmano1]

Depends on your SQL server engine type which you omitted in your post.

[pacmano1]

When I try to do this

Post a screenshot or code. You could be using a DB reader in normal mode, one in JS mode, etc.

[pacmano1]

If it is a plain DB reader an example might be:

DECLARE @return_value int

EXEC    @return_value = [dbo].[spSomeName]
        @TemplateId = N'stuffhere',
        @Limit = 150

[pacmano1]

Are you saying you are getting NO results or your issue is the upper right of your screenshot doesn't show a sample message?

[radamswindber]

Sorry, deleted my last entry because I didn't realize the screenshot had gotten the credentials.

I figured it out. The field name is case sensitive and although my field in the table is ApptGroup, the field I see in the Raw data of the Channel messages is apptgroup. When I change it, it works! Thanks for your time!