Convert Access query with DISTINCTROW in SQL Server query

In Progress

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

SELECT 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]

FROM

TABLE_A,

TABLE_B

INNER JOIN

TABLE_C

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

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

WHERE

(TABLE_C.D4Z6N8=1 AND TABLE_C.D4Z2N8=1)

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

Skills: Database Programming, Microsoft SQL Server, SQL

See more: Scrivere alcuni Software, scrivere alcuni articoli, convert access 2007 query run sql express, convert access 2007 sql server 2005, free convert access database sql server database, sql 2008 convert access, convert access database sql server 2005 express, convert access database sql server database, convert access 2000 sql server 2005, convert access database sql server 2008 database, days will convert access database sql server, convert access database sql server, convert access database sql server 2008, convert access sql server, sql server 2008 convert access database, convert access 2007 sql server 2005 express, convert access aspnet sql server, seller pro software vista compatible, flight reservation software project, sample good software instructions, customer software needed, software development selling clothes, digital signage software company website template, software needed, rfid tags software developers

Project ID: #11756345

Awarded to:

angnut

Provato con DISTINCT? Try with DISTINCT Contattami per maggiori info. Please share me more details More info: http://stackoverflow.com/questions/8562136/distinctrow-equivalent-in-sql-server Ciao Angelo

€14 EUR in 1 day
(11 Reviews)
3.2

37 freelancers are bidding on average €22 for this job

€30 EUR in 2 days
(120 Reviews)
6.4
truongnguyen86

Hello there, i'm expert on writing SQL queries, let me help you with this. Pls share me your bak file in SQL Server. Waiting for your feedback. Thank you!!

€35 EUR in 1 day
(119 Reviews)
6.2
malballah

Dear hiring manager, I am a full stack software developer with 12+ years experience with software development, 8+ years experience with .net framework and sql server and 6+ years experience with asp.net mvc I got More

€30 EUR in 1 day
(16 Reviews)
5.4
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 More

€20 EUR in 1 day
(34 Reviews)
5.4
fanninson45

SHOWCASE An experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. Having the ability to take the technical lead in p More

€24 EUR in 1 day
(10 Reviews)
5.3
ashupathania

I have 5 + years of experience in MSBI Technology (SQL Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Worked on various types of ER diagram More

€20 EUR in 1 day
(32 Reviews)
5.1
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 , Da More

€23 EUR in 1 day
(14 Reviews)
4.5
€34 EUR in 1 day
(4 Reviews)
4.6
AliSafder

It should be easy. Let me do right away. I can work on it. Let me know when to start? I have over 8 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming lang More

€15 EUR in 1 day
(22 Reviews)
4.3
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 t More

€33 EUR in 1 day
(4 Reviews)
4.1
yubor

hi, i am certified mssql server exper (mcse database platform). would be glad to help you

€12 EUR in 3 days
(19 Reviews)
3.8
dekinghtg

A proposal has not yet been provided

€30 EUR in 1 day
(6 Reviews)
3.6
zoloogg

Can you provide me some server to test query. :) Time required : 30 minutes. .....................................

€19 EUR in 0 days
(2 Reviews)
3.2
WeazenSoft

Hello Respected Sir/Madam, We have a team of Microsoft Certified Solution Developer (MCSD) and Design & Development and I have more than 7 years experience in software development and web development using Microsoft More

€29 EUR in 2 days
(4 Reviews)
2.3
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
(1 Review)
2.2
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 definition More

€14 EUR in 1 day
(2 Reviews)
1.5
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 More

€28 EUR in 1 day
(1 Review)
0.7
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
(1 Review)
0.8
€20 EUR in 1 day
(0 Reviews)
0.0
€34 EUR in 1 day
(0 Reviews)
0.0