Database Query

$10-30 USD

Completed

Posted

over 10 years ago

$10-30 USD

Paid on delivery

Table A [Remis_ID] [Asset_status] Table B [Remis_ID] [old_Asset_status] [status_changed_date] Table A [Remis_ID] [Asset_status] 1 4 2 4 3 4 4 4 5 4 6 4 7 4 Table B [Remis_ID] [Old_Asset_status] [status_changed_date] 1 1 12/12/2012 2 1 12/12/2012 3 1 12/12/2012 4 1 12/12/2012 5 1 12/12/2012 1 2 12/20/2012 2 2 12/20/2012 3 2 12/20/2012 4 2 12/22/2012 5 2 12/22/2012 1 3 12/30/2012 2 3 12/30/2012 3 3 12/30/2012 4 3 12/30/2012 5 3 12/30/2012 6 3 12/10/2012 I need a query that returns: base on Variable date @date = 12/21/2012 I need old_Asset_status from table B based on the Min([status_changed_date]) where the [status_changed_date] > @date When the REMIS_ID is not in Table B or there is no date > @date then return Asset_status From Table A [Remis_ID] [Old_Asset_status] 1 3 2 3 3 3 4 2 5 2 6 4 7 4

Database Administration

SQL

Project ID: 5355845

About the project

7 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@akiles99

Hi, Hope this is for mysql . I have write more than 1000 stored procedures and complex sql and i can get it done for you quickly. Thanks, akiles

$30 USD in 1 day

4.9

(31 reviews)

4.3

7 freelancers are bidding on average $41 USD for this job

@paris2785

VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check feedback at https://www.freelancer.gr/u/paris2785.html I can start right away. For any questions, please let me know. Paris

$20 USD in 1 day

4.9

(54 reviews)

6.4

@rodelarode

Sir, I am expert in database admisinstarationg in ORacle SQL, MySQL and MSSQL database management systems. I am working as web developer and relational database expert for 3 years and I can create the specified databases in sql and provide you in a few hours. Please share me details. Thanks Rode

$29 USD in 0 day

5.0

(2 reviews)

2.0

@pviveksingh

Hi, This is Vivek, I have 5 years of experience in Website/Web Application development and I have good team that work delicately for me. We have extensive experience in different web technologies like HTML, DHTML, ASP.NET, C#, WCF, WPF, Web services, Sql Server, Ajax, Java Script, Jquery. I have created more than 100 website. I am very interested to working with you. I would appreciate, if you could give me an opportunity. Thanks & Regards Vivekanand Singh

$55 USD in 1 day

0.0

(0 reviews)

0.0

@codepen

Hi Dear, I have gone through your requirement and I am ready to work on this project. I have over 5 years of experience in MySQL and Query Optimization Development. I can start the job immediately. Lets have a quick conversation on the details to proceed further with this project. Looking forward working with you. Regards, Wang.

$20 USD in 0 day

0.0

(0 reviews)

0.0

@yong0912

Hi Dear I can help you. I'm interest only my feedback but not any many budget. I can help you. I'm interest only my feedback but not any many budget. I can help you. I'm interest only my feedback but not any many budget. I can help you. I'm interest only my feedback but not any many budget. I can help you. I'm interest only my feedback but not any many budget. Regards

$23 USD in 1 day