Convert Access query with DISTINCTROW in SQL Server query

Budget €8 - €30 EUR
Bids 37
Average Bid €22
Status Closed

I need to convert this query wrote for Access database into a query usable in SQL Server database (main problem is DISTINCTROW):


[url removed, login to view],

[url removed, login to view],

[url removed, login to view] AS IIBDCD,

[url removed, login to view] AS IIBHNB,

[url removed, login to view] AS IIBINB,

[url removed, login to view] AS AnaUnica,

[url removed, login to view] AS IIP6CD,

[url removed, login to view] AS IIP8CD,

[url removed, login to view] AS IIAANR,

[url removed, login to view] AS IIAFNR,

[url removed, login to view] AS IISXST,

[url removed, login to view],

[url removed, login to view],

[url removed, login to view] AS IIAGST

INTO [005- Contributi >1993]






ON ([url removed, login to view] = [url removed, login to view])

AND ([url removed, login to view] = [url removed, login to view])



OR (TABLE_C.D4Z2N8=7 AND [url removed, login to view]>1993 AND [url removed, login to view]<>"A")

Get Free Quotes For A Project Like This

This project was awarded to


This is the second time I have worked with Angelo and I am even more impressed. He solved my issue quickly and was thorough in his explanation. Will definitely hire again! [23 October, 2015] Fantastic work as usual. Will definitely rehire!
About the Freelancer
angnut Profile Picture

I am a passionate programmer and software architect with over 14 years of experience in design and development client/server, web based and n-tier application, using Microsoft .NET and SQL Server. I have good technical and analytical experience and problem solving skill. I have managed international projects in healthcare domain. Over the years I have led teams of developers and leading the production process of framework and business solution. I received the B.S. degree in Computer Science from the University of Salerno. More info:

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • CodeWraith Profile Picture


    United States

    I currently work as a Data Scientist within the Finance sector though have worked in areas such as Education, Aviation and Start Up Companies. I am fully conversed in the majority of the SQL Stack as well as tsql development and DBA tasks. As well as being a SQL professional I have an interest in anything IT from Big Data which I have been self training myself in the technologies used and general IT software issues relating to Microsoft.

  • dat2na Profile Picture


    Tbilisi,  Georgia

    Senior database administrator and programmer. Consultant and certified database administrator and developer with 8+ years experience working with SQL Server 2016, 2014, 2012, 2008, 2005 and 2000 . Business solutions consultant and implementer. With many years extensive experience in the IT and other business industries in a variety of roles. My objective is to use my experience to bring creative and top level solutions to businesses that requires a SQL Server Database.

  • yubor Profile Picture


    Moscow,  Russian Federation

    15+ years of experience in software development and system/network administration. - MS SQL Server expert (MCSE: Data Platform) +deep knowledge of SSRS, SSIS, SQLCLR, SQLXML. - Oracle, DB2, MySQL, IB/FB, PostgreSQL developer. - XML, XSLT, XSL-FO, XPath, XQuery, MS Office XML and other XML stuff. - MS Office development with VBA, VB6, VSTO. - Distibuted/SOA programming with WinSock2, DCOM, CORBA, .Net Remoting, XML Web services, WCF services. - Administering Cisco, DLink, APC devices, Windows Server NT4-2012. “He managed to solve what everybody else told me was impossible!” ©sevw - is best matching review for my work.

  • indcsp Profile Picture


    Pune,  India

    Education: Masters Degree in Computer Science Highlights: - Sound technical background; strong understanding of database technologies; software development, web-based application design, object-oriented programming and advanced mobile development. - Process champion; Designed and deployed new policies and processed that improved efficiency while reducing volume of mistakes. - Excellent communicator; leverage technical, business and financial acumen to communicate effectively with clients and their teams. Achievements: - Have designed, developed and implemented multi-million dollar projects aligning business goals with technology solutions to drive process improvements, competitive advantage and sustainable business units. - Have designed, guided and mentored multiple teams in the fields of Product and project development in web based technologies - Have been instrumental in establishing processes and manuals to reduce response time

  • WeazenSoft Profile Picture


    Jaipur,  India

    I have more than 7 years of experience in software development and we have a team of Eleven Gurus. Over these years, We have developed many successful applications both on the web & Windows platform. We have strong knowledge in .Net and SQL related works. Why us: Why you will work with us and not with other software firms, you been working for years and won your trust. We take great pride in the fact that we're easy to talk to, flexible, and fun to work with! There are certain factors that make us a powerhouse of innovation and set it apart from its competitors. We believe that listening is the very first step of solving. We invest in understanding your needs. It's a mindset. We promise to deliver the work with quality and half the time as compare to others, we believe in our self and we know we can take this challenge and give you the desired result, ASAP with Quality. This will help you to develop trust on us, and work with us in all future assignment.

  • Ragav38 Profile Picture



    I am an expert in database architecture. I have 7 years of working experience in IT industry particularly working with MS SQL Server technology.

  • nikpren Profile Picture


    Miami,  United States

    I am an HR/IT Professionnal with 5+ years of experience. I have developed many applications for previous employers including: - Excel Payroll and Tax Application - Excel VBA Leave Tracker Application (with sign-in capability) - Multi-user Access Employee/Jobs Management System - Web HRMS using HTML, CSS, Javascript, PHP, MySql - Computer/Network Back-up Utility using BATCH scripting - Youtube playlist Dowloader using VBScript (I sell this one)

  • toobahanif Profile Picture



    I have almost 2 years experience in a corporate where i developed Microsoft SQL Reports and QlikView Dashboards. Now I want to work as a freelancer.

  • Dilkushp Profile Picture


    Bangalore,  India

    Expert with SQL, SQL Azure, ETL, .Net

  • eduardojoseramos Profile Picture


    Cabudare,  Venezuela

    Software Architect with experience in Database Design, Framework design. Web and Desktop apps using Java,Spring,Hibernate, Echostudio, Eclipse, SVN. JaspertReport Design. App and Database Integration/migration. Hql, Sql. Hardware Security Module (HSM). Fortigate 60C configuration and administration. Datacard CP60 plus (Apps).