Saturday, November 23, 2013

Keyword DISTINCT,LTRIM, RTRIM not working properly

I got the solution to my first problem,


There are several trailing spaces and leading too. and these are different in those duplicate rows. I couldn't see them by naked eyes, but when I calculated the length of those attributes, I saw the difference.


Thanks 4 replies.


But I am still struggling with my second Snapshot problem.




Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.


No comments:

Post a Comment