web stats
Mirth Community - View Single Post - Need to pass delimited string for IN clause
View Single Post
Old 10-08-2019, 10:23 AM
clarksss clarksss is offline
OBX.2 Kenobi
Join Date: Jul 2013
Posts: 76
clarksss is on a distinguished road
Thumbs up Solution --

I kept the Mirth code the same,
but in my stored procedure the code was changed to this:

 WHERE reg.Location_MisLocID IN (SELECT value FROM STRING_SPLIT(@RuleBuilderProfileLocations, ','))
thanks to everyone who had ideas.
Reply With Quote