I have a Ranking Leaderboard View for my web app which doesn't show any duplicated rows when run in SQL Server. However, when my Web App returns the rows, multiple columns are duplicated and I'm not sure why. I've indexed the table appropriately and rebuilt any fragmented indexes thinking this may be the cause of the issue, but it has not worked.
Ignore the Rank numbers in the picture, this is because some people have the same rating. I have ordered the table by Username. The colours represent different usernames. Is there any reason this would be happening on the application side and not database side?
Aucun commentaire:
Enregistrer un commentaire