| http://www.w3.org/ns/prov#value | - patel i see what you are asking, but i do not see the data reflecting something that allows it to beswitched like that;about all i can suggest is a UNION and statements that reflect the desired ranges.;SELECT ROW_NUMBER() OVER (PARTITION BY RowNumber order by RowID) ,RowID ,TodaysDate ,Name ,RowNumberwhere rowid <=20UNION ALLSELECT ROW_NUMBER() OVER (PARTITION BY RowNumber order by RowID) ,Ro
|
