Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 ROW_Number

Author  Topic 

JanakiRam
Starting Member

22 Posts

Posted - 2013-07-24 : 08:34:01
Hi.,

when creating row_number duplicate will appear how avoid it

JanakiRam

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-07-24 : 08:40:52
How are you generating row numbers? If you are using the ROW_NUMBER function, that should not generate duplicates unless you have a partition by clause. Are you able to post your query and some sample data?
Go to Top of Page
   

- Advertisement -