Hello, I need to build a MS SQL 2008 Function (I think I need a Function). I have a table with the following data (see attached):
ID | Reference | Category
ID = Guid
Reference 0 varchar(20)
Category = Tinyint
Inside a specific Category (for example WHERE Category = 1), I need to sort the data DESC using the "Reference" column; the problem is that this column is string, so standard sorting is wrong (for example, A100 comes before A 10). In other words, I need to display the data in a sorted way within the same Category. For example, if I choose Category = 3, I should have:
A419
A418
A417
...
A01
The Function should accept in input a parameter specifying the Category I want to sort (sorting is always DESC). According to the Category type, you can "understand" how to sort data. We can have 11 category types:
0 = the reference is composed of numbers only
1 = the reference is composed of numbers only followed by "/" and a number (sorting should be on the left number)
2 = the reference is composed of numbers only followed by "/" and a letter (sorting should be on the left number)
3 = the reference is composed of "A" followed by a number
4 = the reference is composed of "ST" followed by a number
5 = the reference is composed of "R" followed by a number
6 = the reference is composed of "S" followed by a number
7 = the reference is composed of "E" followed by a number
8 = the reference is composed of "O" followed by a number
9 = the reference is composed of "SP" followed by a number
99 = Unkown
I'm attaching the c# code I used to map the Category from the Reference, maybe this code may inspire you (I think a similar code should be written in SQL to get the "numeric" part of the Reference and then sort DESC by it).
From an SQL point of view, when your Function is ready I'd like to write something like:
SELECT * FROM Products WHERE Category = 3 ORDER BY YourFunction(3)
For any questions, just ask.
*** I need this project to be completed in max 3 hours from now ***
i am a lead .Net software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
$30 USD in 1 day
4.7 (98 reviews)
6.6
6.6
4 freelancers are bidding on average $25 USD for this job
hello client,
i can build a MS SQL 2008 Function
My skills are PHP, Yii, code igniter, MySQL, Apache, Redis. Experience with API development and integration.
- all site were done by me from 0. I got just PSD files and did all responsive HTML coding for MAC/Win: FF/Chrome/IE/Safari
Thank you for sharing such interesting project and opportunity to bid on it.
Regards
Ruchi
Hello sir,
Thank your very much for your job posting
I will do this
I would be excited to participate in the work.
I have gone through the complete requirement and I will be happy to do that I will complete your work in required timeline.
i have More than 18 years of Customize Software Developing in .Net and C# , Developing Database & software QA testing experience, also accomplished many products & customize web applications for various verticals.
Success is my main aim. I gain success by hock or by crook. And I have a strong belief that I will be able to satisfy you in this project. Hope I will be hired.
I am always available on Email and Skype. I will be available more than 60 hours per week and able to start your project as soon as possible according to you.
Sir More Information in my Profile so plz sir visit my profile
Thank you for your consideration
Best Regards
EONDOTCOM