Sean Lange (5/8/2013)
What are the results of these two queries?
select COUNT(*) FROM #Delivery Where cast(delivery as int) = 83535308
select COUNT(*) from details_2 where cast(details_2.Delivery_Doc as int) = 83535308
One (Delivery) and zero (details_2)... that is what makes this so darn strange. If you do an inner join you come up with nothing.
I have found one other strange thing..
The outer join has data in the columns for details_2, so I do not understand how in the heck it is doing the link between the two tables... there shouldn't be anything on the details_2 side.