How 2 index the grouping rows??

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

You can't index like that on sqlserver... However you can do a covering index on those 2 columns which would speed up the query.

ofir shoval Ten Centuries Points: 1278 More actions · Answer 2

Ten Centuries

Points: 1278

August 22, 2005 at 7:20 am

Is there a trick in the RS himself 2 it???

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Surely but I can't guide in there... someone else surely will.

nigel. SSChampion Points: 11636 More actions · Answer 4

Use the RowNumber function in the expression for the city ie.

=RowNumber("<put your group name here>") & "." & Fields!city.value

ofir shoval Ten Centuries Points: 1278 More actions · Answer 5

thanks

find refernce in:

ofir shoval Ten Centuries Points: 1278 More actions · Answer 6

Note:

if u want 2 index group2 u shuold write the RowNumber("group1_name")