IN ('A-10', 'A-12', 'B-10', 'B-15')

Select
MType,
Value,
Time
from (
select
'A-'+cast(MType as varchar(10)) as pair
MType,
Value,
Time
from Table_A
union all
select
'B-'+cast(MType as varchar(10)) as pair
MType,
Value,
Time
from Table_И
)
where pair IN ('A-10', 'A-12', 'B-10', 'B-15')
and Time between '2016-01-01' and '2016-01-02'

'A-'+cast(MType as varchar(10)) as pair

Select MType from MType_list where 'A-'+MType in ( список значений )

ALTER function [dbo].[ParseStr] (@s varchar(max), @delim varchar(100))
returns table
as
return (
	with cte as(
		select cast(1 as int) N, cast(1 as int) p1, isnull(nullif(CHARINDEX(@delim, @s),0),LEN(@s) + 1) p2
			union all
		select cast(N + 1 as int), cast(p2 + datalength(@delim) as int),
			   isnull(nullif(CHARINDEX(@delim, @s, p2 + datalength(@delim)),0),LEN(@s) + 1)
		from cte
		where p2 < LEN(@s)
	)
	select N, SUBSTRING(@s, p1, p2-p1) val 
	from cte
)

Select ... where ... and MTType in #in_cond# and Time between #DT1# and #DT2#