asked
Lookup Table not working
Let me start by naming my two tables: My first table is Table2 second is LookupTbl2 I have a weird situation that I need some help on. So Table2 joins to LookupTb12 to map certain terms. Now about 90% of the values map correctly. They other 10% show NULL after I join them. The terms match exactly in both tables (spaces and all): How can this be I am assuming they have different BinaryValues somehow Any ideas how to resolve this?
Its a inner join in a subquery. Forget about the lookup table for a second I'll even make this simpler. If I just run a simple select statement with a where clause specifying the term it returns zero rows. I copy the term straight from the results grid of Management Studio. Select * from Tabl2 Where term = 'Hello' (THIS Retruns nothing and I copy and paste the term)
I seem to have found the issue...I was importing a tab delimited file and the terms that were troublesome were spread across multiple lines of the file. Once I corrected this in the import file Everything worked correctly. Although it was a pain going through that whole file.
10 People are following this question.
