Make a set from CSV values in TSQL
Posted
by rossfabricant
on Stack Overflow
See other posts from Stack Overflow
or by rossfabricant
Published on 2010-03-24T14:56:58Z
Indexed on
2010/03/24
15:53 UTC
Read the original article
Hit count: 116
Filed under:
tsql
If I want to see which values from an Excel spreadsheet column don't match values in a table, I can easily create a table with Bulk Import. Is there a simpler way? EG, I want to do a query like:
select into #temp from ('a', 'b', 'c') as 'Id'
select * from #temp where Id not in (select Id from MyTable)
© Stack Overflow or respective owner
