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
 Analysis Server and Reporting Services (2008)
 RowNumber By Group

Author  Topic 

diamond5
Starting Member

15 Posts

Posted - 2009-12-02 : 10:41:38
Hello again,
i want set row number function by group only and not count row numbers in details in it"the group" .

i had used RowNumber function so that numbering rows but in this case contain the row group > details and i want to numbering the group only.
plz help me..

Thanks...

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-12-03 : 12:19:39
Possibly do as a calculated field in your SQL?

John
It's a small world (but I wouldn't want to paint it)
Go to Top of Page

jhunt428
Starting Member

3 Posts

Posted - 2010-03-25 : 16:25:14
Hi Diamond5,

Did anyone ever get back to you on this? I have the same question and was wondering if you have the answer.
Thanks,

Julia

Julia C. Hunt
Technical Support Specialist
Florida Keys Aqueduct Authority
www.fkaa.com
Go to Top of Page
   

- Advertisement -