InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 23:29:38 GMT20http://www.sqlservercentral.com/Forums/Topic515092-338-1.aspxWell done. :)Wed, 11 Jun 2008 07:06:12 GMTKent Waldrophttp://www.sqlservercentral.com/Forums/Topic515092-338-1.aspxHi Kent,Thanks for your help, I've managed to get it work using the ROW_NUMBER and partition by clause.Wed, 11 Jun 2008 06:58:15 GMTDavid-155102http://www.sqlservercentral.com/Forums/Topic515092-338-1.aspxPlease give a look at the "ranking" functions such as "row_number()" and "rank()" in books online. Pay particular attention to use of the OVER() clause in conjunction with both the PARTITION BY and ORDER BY clauses.KentWed, 11 Jun 2008 06:09:55 GMTKent Waldrophttp://www.sqlservercentral.com/Forums/Topic515092-338-1.aspxIs it possible to add a sequence number to rows such that it resets on the start of each grouping? For example, using the following code:[code]create table myTable (sales_person varchar(10), model varchar(10), date_sold datetime)insert into myTable (sales_person, model, date_sold)values ('David','A', cast('2008-01-01' as datetime))insert into myTable (sales_person, model, date_sold)values ('David','A', cast('2008-01-02' as datetime))insert into myTable (sales_person, model, date_sold)values ('David','A', cast('2008-01-03' as datetime))insert into myTable (sales_person, model, date_sold)values ('Fred','A', cast('2008-01-01' as datetime))insert into myTable (sales_person, model, date_sold)values ('Fred','A', cast('2008-01-04' as datetime))insert into myTable (sales_person, model, date_sold)values ('Fred','A', cast('2008-01-06' as datetime))select * from myTabledrop table myTable[/code]I would like the results to be:1, David, A, 2008-01-012, David, A, 2008-01-023, David, A, 2008-01-031, Fred, A, 2008-01-012, Fred, A, 2008-01-043, Fred, A, 2008-01-06Note that the first column (the sequence number) is reset upon each group being the sales_person and potentially the model in this example.ThanksWed, 11 Jun 2008 05:59:54 GMTDavid-155102