Viewing 7 posts - 1 through 7 (of 7 total)
ChrisM@Work (9/28/2012)
Barry Couch (9/27/2012)
CASE @SortColumn WHEN 'StreetName' THEN Maintainer + ', ' + StreetName END ASC,but how could I do something like sorting by Maintainer ASC and StreetName DESC?
You will...
September 28, 2012 at 5:47 am
ChrisM@Work (9/28/2012)
Barry Couch (9/28/2012)
opc.three (9/27/2012)
If not, or you must do this in the database, you could...
September 28, 2012 at 5:43 am
Sean Lange (9/27/2012)
September 28, 2012 at 5:37 am
opc.three (9/27/2012)
If not, or you must do this in the database, you could look into using...
September 28, 2012 at 5:32 am
That looks like that will probably work, however I have 12 columns, any 1 or more can be selected for sorting in any order and each one in either direction....
September 27, 2012 at 11:54 am
Sure. Here is what I have currently which works fine for single columns sorts.
BEGIN
insert into #QualifyingStreets
...
September 27, 2012 at 8:57 am
Alex,
This is AWESOME. This is going to save me a heap of time. Thanks a million for sharing.
-Barry
October 10, 2008 at 6:07 am
Viewing 7 posts - 1 through 7 (of 7 total)