SQL Join Rewrites

$10-30 USD

Dokončeno

Zveřejněno

skoro před 6 roky

$10-30 USD

Zaplaceno při doručení

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

IČ projektu: 17470612

O projektu

13 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@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 v 1 dni

5,0

(141 recenze)

7,3

13 freelanceři nabízejí v průměru $29 USD za tuto práci

@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 v 1 dni

4,9

(53 recenze)

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 v 0 dni

4,9

(25 recenze)

6,0

@younasmalik

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

$30 USD v 1 dni

5,0

(14 recenze)

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 v 1 dni