Ok. This is my assumption based on what being posted here. The current query is returning @ChannelTypeValues = 'FGBO','IB','Manual Upload - FGB'? And the next invisible/secret query will use that variable as a filter? [SELECT * FROM SECRETTable WHERE secretColumn IN @ChannelTypeValues ]???
Here how the query can accomplish the above scenario.
DECLARE @ChannelTypeXml xml
DECLARE @tempChannelType TABLE (ChannelType VARCHAR(50))
DECLARE @tempDummy TABLE (Column1 VARCHAR(50), ChannelType VARCHAR(50))
SET @ChannelTypeXml='<ROOT><CHANNELTYPE><CHANNEL>FGBO</CHANNEL></CHANNELTYPE>
<CHANNELTYPE><CHANNEL>IB</CHANNEL></CHANNELTYPE>
<CHANNELTYPE><CHANNEL>Manual Upload - FGB</CHANNEL></CHANNELTYPE></ROOT>'
INSERT INTO @tempDummy
SELECT 'abcd','FGBO' UNION
SELECT 'xyz','IB' UNION
SELECT 'Kitty','CAT' UNION
SELECT 'hijk','Manual Upload - FGB' UNION
SELECT 'Woof Woof','DOG';
INSERT INTO @tempChannelType
SELECT t.c.value('CHANNEL[1]','varchar(100)')
FROM @ChannelTypeXml.nodes('//ROOT/CHANNELTYPE') T(c)
SELECT * FROM @tempChannelType
SELECT * FROM @tempDummy WHERE ChannelType IN (SELECT * FROM @tempChannelType)
Place the channelvalue extracted from XML into a temporary table
ChannelType
FGBO
IB
Manual Upload - FGB
Apply the filter results
Column1 ChannelType
abcd FGBO
hijk Manual Upload - FGB
xyz IB