InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 20:20:33 GMT20http://www.sqlservercentral.com/Forums/Topic1384522-391-1.aspx[quote][b]tonyarp05 61903 (11/14/2012)[/b][hr]No still doesnt work, its happening based on seq_no only.PFA[/quote]The output appears to be sorting exactly as specified. It's ordered first by SeqNum and then within each group of SeqNum they are ordered by Date (some of which appear to be blank or null). Another option is to look up some articles on using the ROW_NUMBER() operator for creating nested ordering. That operator can let you do just about any grouping/sorting you want by creating "sort" columns for as many levels or groups you need. This method can be a bit complex, but if you give us some data examples and the desired output then perhaps one of us can give you specific examples to get your desired result. Thu, 15 Nov 2012 10:35:35 GMTSteven Willishttp://www.sqlservercentral.com/Forums/Topic1384522-391-1.aspxIn addition, please take the time to read and following the instructions in the first article I have referenced below in my signature block regarding asking for help.We really need the DDL (CREATE TABLE statement) for the table(s) involved, sample data (as a series of INSERT INTO statements) for each table, the expected results based on the sample data, and most importantly your code you are using now.Beyond that, all you are going to get based on an image is guess work, and my crystal ball hasn't worked in years.Wed, 14 Nov 2012 07:18:04 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1384522-391-1.aspx[quote][b]tonyarp05 61903 (11/14/2012)[/b][hr]Hi,I have query to execute the output.It should be sorted with date also, but its sorting with only Seq_no.PFA - for more detailsplease help me on this.[/quote]I agree with what Stewart posted. You're missing some date data. Do you want that filled in? If so, what order do you wannt the dates to "smear" down in? By Seq-No???Wed, 14 Nov 2012 07:17:42 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1384522-391-1.aspxPlease provide an example of how you expect the output to appear.Per the screenprint, only one of each sequence has a date, which appears with the first row of each sequence.Wed, 14 Nov 2012 06:40:13 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1384522-391-1.aspxNo still doesnt work, its happening based on seq_no only.PFAWed, 14 Nov 2012 04:50:04 GMTtonyarp05 61903http://www.sqlservercentral.com/Forums/Topic1384522-391-1.aspxHave you tried adding the Date column to the ORDER BY clause[code="sql"]ORDER BY Seq, Date[/code]Wed, 14 Nov 2012 04:43:23 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1384522-391-1.aspxHi,I have query to execute the output.It should be sorted with date also, but its sorting with only Seq_no.PFA - for more detailsplease help me on this.Wed, 14 Nov 2012 03:55:20 GMTtonyarp05 61903