[thelist] Sorting with SQL
Keith Underdown
keith.underdown at qconsultancy.co.uk
Wed Sep 24 10:53:57 CDT 2003
On Wed, 24 Sep 2003 09:35:13 -0500, Rob Smith <rob.smith at THERMON.com>
wrote:
>> it would help to know which database you're using...
>
> rudy,
>
> It's SQL Server 2k.
>
> In some cases I will have:
>
> LLL N-N
> LLL NN-N
> LL N-N
>
> .:. Where L stands for Letter and N stands for Number
Are these hierarchic? In other words is the alphbetic part really the key
to a parent object (Product Line to Product for example). If it is it
would be better to get the analysis right and use the foreign key of the
parent as the first part of a multiple sort.
Keith
--
Keith Underdown (Managing Director)
The Q Consultancy Ltd
KALIDO Information Archtectures Specialists
+44 7798 934782
www.qconsultancy.co.uk
More information about the thelist
mailing list