Convert Access query with DISTINCTROW in SQL Server query

€8-30 EUR

Completed

Posted

over 7 years ago

€8-30 EUR

Paid on delivery

I need to convert this query wrote for Access database into a query usable in SQL Server database (main problem is DISTINCTROW): SELECT DISTINCTROW [login to view URL], [login to view URL], [login to view URL] AS IIBDCD, [login to view URL] AS IIBHNB, [login to view URL] AS IIBINB, [login to view URL] AS AnaUnica, [login to view URL] AS IIP6CD, [login to view URL] AS IIP8CD, [login to view URL] AS IIAANR, [login to view URL] AS IIAFNR, [login to view URL] AS IISXST, [login to view URL], [login to view URL], [login to view URL] AS IIAGST INTO [005- Contributi >1993] FROM TABLE_A, TABLE_B INNER JOIN TABLE_C ON ([login to view URL] = [login to view URL]) AND ([login to view URL] = [login to view URL]) WHERE (TABLE_C.D4Z6N8=1 AND TABLE_C.D4Z2N8=1) OR (TABLE_C.D4Z2N8=7 AND [login to view URL]>1993 AND [login to view URL]<>"A")

Database Programming

Microsoft SQL Server

SQL

Project ID: 11756345

About the project

31 proposals

Remote project

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

@angnut

Provato con DISTINCT? Try with DISTINCT Contattami per maggiori info. Please share me more details More info: [login to view URL] Ciao Angelo

€14 EUR in 1 day

5.0

(20 reviews)

4.2

31 freelancers are bidding on average €22 EUR for this job

@codetod

Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. With my domain expertise in the ERP, when ever I have a business requirement, I can easily look into a database, identify the required tables and write the required query for that. Distinctrow and Distinct most of the time return same results. I would like to discuss and know if there is a specific reason or scenario why you have used distinctrow, and will have to code the logic accordingly in the SQL. Look forward to hear from you. Thanks Roni

€20 EUR in 1 day

5.0

(77 reviews)

6.4

@arityinfoway

Hello Sir, I have gone through your requirements regarding Convert Access query with DISTINCTROW in SQL Server query. we brief and understand your idea and preference for job as you are looking for. I have more than 6+ years of experience in .NET, c#.net, vb.net, asp.net, MVC, Odoo, sql, mysql, Oracle, Azure, Entity Framework, Linq, Umbraco, Telerik, Devexpress, JQuery, Angularjs, CSS, HTML, Kendo UI, RDLC Report, Crystal Report, BioMetric Integration. I have developed more than 20 projects. Please send me message for further conversation. Thanks, Arity Infoway

€33 EUR in 1 day

5.0

(12 reviews)

5.3

@shahzaib121

Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. I have done many work in Requirements analysis , Data Staging, Data Warehouse, DataBases. I am expert in developing ERD, Front-End, Backend, Security, Optimization, SSIS, SSRS. I have strong command on queries too.I see your work & too much interesting in your work. My rates is also too much low. I assure you I am the best for your work. Kindly reply me so that we negotiate on price & then start working on it Have a good day Thank you

€23 EUR in 1 day

4.8

(22 reviews)

4.7

@dat2na

Greetings, I'm professional database expert with 8+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like database administration and development by remotely. I'm top expert. -- Best regards, Davit Dartsimelia Senior Database Administrator & Developer

€34 EUR in 1 day

5.0

(4 reviews)

4.4

@dekinghtg

A proposal has not yet been provided

€30 EUR in 1 day

4.9

(8 reviews)

3.7

@eduardojoseramos

Hi! I offer my Consulting Services to Fix your SQL script. I will need the table definitions and some data because the Script is not complete, there are some conditions missing but I need analyze the tables definitions and data! The DistinctRow was added to remove duplicate rowsbut it was not a efficient solution! Best Regards Your Freelancer Eduardo Ramos Venezuela

€14 EUR in 1 day

5.0

(3 reviews)

2.6

@Dilkushp

I'm not sure why this is a question. you have DISTICT keyword in SQL which will replicate this DISTICTROW of Access DB. I hope this helps.

€24 EUR in 1 day

5.0

(2 reviews)

2.3

@manu0417

I am a Microsoft Data Platform MVP and work on migrations day in and day out. I am confident that I will be the best resource to get this solved for you on freelancer.

€24 EUR in 1 day

5.0

(1 review)

0.8

@sunilsofteg2006

I am having 10+ years of experience of SQL development. I have worked on small databases to large databases in sql and solved the problems very effectively. Can you please provide some sample data of TABLE_A, TABLE_B and TABLE_C for more analysis and understanding ?

€28 EUR in 1 day

5.0

(1 review)

0.5

@donka92

I`ve been working as a datawarehouse developer for the past 2 years. I work mainly with oracle pl/sql developer as I create tens of functions, procedures and queries on regular basis. I believe I am the candidate you are looking for.

€23 EUR in 1 day

0.0

(0 reviews)

0.0

@shwetagupta1991

My expertise in SQl and I have worked on similar queries earlier previously. Hoping to get some more projects like this

€19 EUR in 1 day

0.0

(0 reviews)

0.0

@aorlivska

Hello! My name is Oleksandra and I’m an IT manager at ServerSupport.pro. I work in a team of specialists with 8+ years of experience in System Administration. Your project is quite interesting and our team can do it. Tell me more about your project. I'll be happy to discuss further details. Best,Oleksandra

€26 EUR in 1 day

0.0

(0 reviews)

0.0

@prashantkprabhat

I am experienced in SQL Server and T-SQL. I understand the requirement of the project and can do as needed. Thank you.

€23 EUR in 1 day

0.0

(0 reviews)

0.0

@hoconghoai

Hello, I'm expert to query SQL Server. I can help you convert this query to SQL Server. =================================================

€13 EUR in 1 day

0.0

(0 reviews)

0.0

@nehagarg511

I have a good knowledge of SQL and can correct this SQL in minutes. Please provide me the opportunity to prove myself.

€8 EUR in 1 day

0.0

(0 reviews)

0.0

@geetumishra76

I have an indepth knowlwdge of database and have worked on this technology for 12 years. I have worked as an Architecture in SQL Server, so i think i can give full justice to your query.

€24 EUR in 1 day

0.0

(0 reviews)

0.0

@nikpren

Dear employer, I have read the details of your job and I believe I am a great fit. Please take a look at my profile to see my achievements. We can discuss further over chat. Thank you.

€23 EUR in 1 day

0.0

(0 reviews)

0.0

@Ragav38

BID PROPOSAL: The proposal details are mentioned below: The final bid amount is 12 Euros ETA - 1 day

€12 EUR in 1 day

0.0

(0 reviews)

0.0

@indcsp

Hey, try this SELECT DISTINCT A.* FROM A INNER JOIN B ON A.a_id = B.a_id From reading the documentation on distinctrow, it looks like you want an exists clause or (for generally better performance) a join. Hope this solves your problem. It works.

€8 EUR in 1 day

0.0

(0 reviews)

0.0

@CodeWraith

Hi, I am a full time SQL Developer/DBA and data scientist with over 20 years experience in tsql and the entire BI stack as well as MS Access. I will complete any work to the decided specification and am also happy to make recommendations for further improvement if I think it will better the end project for the client. All my development is currently done in SQL Server 2012 but if needs be I can complete the work in which ever version is best for the client. If there is anything else that I can help you with please contact me through the site. I look forward to hearing from you. Phil Dodgson

€17 EUR in 1 day