BegTag     EndTag
---------- ----------
3260       3309
3310       3329
3330       3369
3370       3384

TagNumber
----------
3620
3621
3633
36122122
3634
2753

select TagNumber
from dbo.InventoryWipTags 
where TagNumber not IN(select *
		       from dbo.InventoryTagMaster
		       where PhysInvDate = '2010-02-18'
		AND TagNumber between min(BegTag) AND max(EndTag))

Msg 147, Level 15, State 1, Line 6
An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
Msg 116, Level 16, State 1, Line 6
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

SELECT m.BegTag,m.EndTag,m.Val
FROM
(
SELECT t.BegTag,t.EndTag,t.BegTag+ v.number AS Val
FROM Table t
CROSS JOIN master..spt_values v
WHERE v.type='p'
AND t.BegTag+ v.number <=t.EndTag
)m
LEFT JOIN Table2 t2
ON t2.TagNumber=m.Val
WHERE t2.TagNumber IS NULL

BegTag     EndTag     Val
---------- ---------- -----------
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value 'asd' to data type int.