En curso

Convert Access query with DISTINCTROW in SQL Server query

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")

Habilidades: Programación de bases de datos, Servidor de Microsoft SQL , SQL

Ver más: 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

Información del empleador:
( 34 comentarios ) Bergamo, Italy

ID de proyecto: #11756345

Adjudicado a:

angnut

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

€14 EUR en 1 día
(11 comentarios)
3.2

37 freelancers are bidding on average €22 for this job

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 en 1 día
(119 comentarios)
6.2
€30 EUR en 2 días
(120 comentarios)
6.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 Más

€20 EUR en 1 día
(34 comentarios)
5.4
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 Más

€30 EUR en 1 día
(16 comentarios)
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 Más

€24 EUR en 1 día
(10 comentarios)
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 Más

€20 EUR en 1 día
(32 comentarios)
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 Más

€23 EUR en 1 día
(14 comentarios)
4.5
€34 EUR en 1 día
(4 comentarios)
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 Más

€15 EUR en 1 día
(22 comentarios)
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 Más

€33 EUR en 1 día
(4 comentarios)
4.1
yubor

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

€12 EUR en 3 días
(19 comentarios)
3.8
dekinghtg

A proposal has not yet been provided

€30 EUR en 1 día
(6 comentarios)
3.6
zoloogg

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

€19 EUR en 0 días
(2 comentarios)
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 Más

€29 EUR en 2 días
(4 comentarios)
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 en 1 día
(1 comentario)
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 Más

€14 EUR en 1 día
(2 comentarios)
1.5
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 en 1 día
(1 comentario)
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 Más

€28 EUR en 1 día
(1 comentario)
0.7
€34 EUR en 1 día
(0 comentarios)
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. Hop Más

€8 EUR en 1 día
(0 comentarios)
0.0