February 4, 2009 at 5:43 am
Hi
I am working on an ASP.Net app with MS SQL 2005 as the back end
I wish to sort the data in all the nvarchar type fields as follows:
1, 1.1, 1.1.2, 1.2, 2.0, ...... 10.1, .... A1....etc
Can you please guide me through what needs to be done? If possible,I would also like to set this as the default sort.
Thanks
Adish
February 4, 2009 at 7:13 am
I think you'd have to use CLR to create a sort for this. I've never done it, but if you perform a search, there is sample code available.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
February 5, 2009 at 9:03 am
Thanks Grant, I will try that out. Maybe I should be looking for the solution on .Net forums also.
Adish
February 5, 2009 at 10:14 am
Possibly. But I think there might be some samples for how to do it locally.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply