Em Andamento

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: Programação de Banco de Dados, Microsoft SQL Server , SQL

Ver mais: 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

Acerca do Empregador:
( 34 comentários ) Bergamo, Italy

ID do Projeto: #11756345

Premiar 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 em 1 dia
(11 Avaliações)
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 em 1 dia
(119 Comentários)
6.2
€30 EUR in 2 dias
(120 Comentários)
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 Mais

€20 EUR em 1 dia
(34 Comentários)
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 Mais

€30 EUR em 1 dia
(16 Comentários)
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 Mais

€24 EUR em 1 dia
(10 Comentários)
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 Mais

€20 EUR em 1 dia
(32 Comentários)
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 Mais

€23 EUR em 1 dia
(14 Comentários)
4.5
€34 EUR em 1 dia
(4 Comentários)
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 Mais

€15 EUR em 1 dia
(22 Comentários)
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 Mais

€33 EUR em 1 dia
(4 Comentários)
4.1
yubor

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

€12 EUR in 3 dias
(19 Comentários)
3.8
dekinghtg

A proposal has not yet been provided

€30 EUR em 1 dia
(6 Comentários)
3.6
zoloogg

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

€19 EUR in 0 dias
(2 Comentários)
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 Mais

€29 EUR in 2 dias
(4 Comentários)
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 em 1 dia
(1 Comentário)
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 Mais

€14 EUR em 1 dia
(2 Comentários)
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 em 1 dia
(1 Comentário)
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 Mais

€28 EUR em 1 dia
(1 Comentário)
0.7
€34 EUR em 1 dia
(0 Comentários)
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 Mais

€8 EUR em 1 dia
(0 Comentários)
0.0