Need help with SQL server stored procedure
- or -
Post a project like this3306
£20(approx. $25)
- Posted:
- Proposals: 8
- Remote
- #710487
- Completed
PHP/Wordpress/Python/React/Flutter - Web Development,Mobile Development,Data Science
Bay Minette
478239370948560004696248768995812936854422884945
Description
Experience Level: Entry
This is just one Stored Procedure that I am having problems with.
I need it to return a list of adverts which could be in one or more
actualRegion, region1 , region2, region3
so I want to show them in the order of
advertType (paid)
then ones that match actualregion
Then all the rest of the regions which match
then
advertType(free)
then ones that match actualregion
Then all the rest of the regions which match
I have this working now so it gets them ordered by the correct counties but the paid ones do not come before the free ones anymore.
I need it to return a list of adverts which could be in one or more
actualRegion, region1 , region2, region3
so I want to show them in the order of
advertType (paid)
then ones that match actualregion
Then all the rest of the regions which match
then
advertType(free)
then ones that match actualregion
Then all the rest of the regions which match
I have this working now so it gets them ordered by the correct counties but the paid ones do not come before the free ones anymore.
Richard H.
100% (34)Projects Completed
28
Freelancers worked with
28
Projects awarded
32%
Last project
29 May 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies