Paul White (1/13/2010)
forum member (1/13/2010)
My table structure are very big with large quantinty of data so couldn't make a post.There is an error in your code.
Without seeing what you can see (even a simplified example!?) it's difficult to see how to help...?
Big table structure can be handled. As far as the data, just post some of the data that you know represents the issue (10 records maybe that are returned by both inner and left join).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events