SQL Join Rewrites

$10-30 USD

Completed

Posted

almost 6 years ago

$10-30 USD

Paid on delivery

I have about 10 queries I need rewritten from SQL 2005 syntax to SQL 2012 syntax. Errors I am getting say: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '*='. Here is an example of a query I need rewritten. select [login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],renamed,filename,type,website,httptype,passwordlevel,contenttype from customernav,navigation,customerlinks where customernav.customerid=#thecustomer# and customernav.active=1 and [login to view URL]*=[login to view URL] and [login to view URL]*=[login to view URL] and customernav.navigationid=[login to view URL] and [login to view URL] <> '' and [login to view URL] <> '' order by [login to view URL] asc To show me you are skilled, please rewrite this query in its 2012 proper form. For someone that is a SQL expert, this should be super easy.

Database Programming

Microsoft SQL Server

SQL

Project ID: 17470612

About the project

13 proposals

Remote project

Active 6 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:

@customizedata

*= operator is obsolete since many years. It has replaced by outer joins. please provide me access to the data so that i could show how to change it for sql 2012 +.

$30 USD in 1 day

5.0

(141 reviews)

7.3

13 freelancers are bidding on average $29 USD for this job

@feninsoftech

Hi, I have 11 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. Microsoft Certified Technology Specialist in SQL Server. Thanks

$35 USD in 1 day

4.9

(53 reviews)

6.8

@SergioAlfaroV

Hello! I am a Computer Engineer, with a MCSA SQL Server 2014, with more than 10 years of experience using SQL, queries, database management, data warehousing, and related projects and tasks. I am a near-native English speaker, currently available, and results oriented. I am an SQL expert. I can do your requirement, as I've done similar projects before. I have all the MS software required installed on my premises. I'm located in the Central Timezone (GMT -5h). We can discuss details over chat, if you like. Thanks!

$30 USD in 0 day

4.9

(25 reviews)

6.0

@younasmalik

Hi... I am senior software engineer working on database applications... Hire me .. i will deliver your solution asap.

$30 USD in 1 day

5.0

(14 reviews)

4.4

@DHSprout

Hi I have 5+ experience in web development. I have completed many task like this. I have strong knowledge of Mysql, Oracle, Database Design etc. Please check my profile for more about my project details: https://www.freelancer.in/u/DHSprout Thanks, DH

$30 USD in 1 day