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

Навыки: Программирование баз данных, SQL-сервер Microsoft, SQL

Показать больше: 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

ID проекта: #11756345

Поручено:

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 за 1 день
(11 отзывов(-а) )
3.2

37 фрилансеров(-а) подали заявки на эту работу; средняя заявка - €22

€30 EUR за 2 дней(-я)
(120 отзывов(-а))
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 за 1 день
(119 отзывов(-а))
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 Больше

€30 EUR за 1 день
(16 отзывов(-а))
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 Больше

€20 EUR за 1 день
(34 отзывов(-а))
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 Больше

€24 EUR за 1 день
(10 отзывов(-а))
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 Больше

€20 EUR за 1 день
(32 отзывов(-а))
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 Больше

€23 EUR за 1 день
(14 отзывов(-а))
4.5
€34 EUR за 1 день
(4 отзывов(-а))
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 Больше

€15 EUR за 1 день
(22 отзывов(-а))
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 Больше

€33 EUR за 1 день
(4 отзывов(-а))
4.1
yubor

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

€12 EUR за 3 дней(-я)
(19 отзывов(-а))
3.8
dekinghtg

A proposal has not yet been provided

€30 EUR за 1 день
(6 отзывов(-а))
3.6
zoloogg

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

€19 EUR за 0 дней(-я)
(2 отзывов(-а))
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 Больше

€29 EUR за 2 дней(-я)
(4 отзывов(-а))
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 за 1 день
(1 отзыв)
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 Больше

€14 EUR за 1 день
(2 отзывов(-а))
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 Больше

€28 EUR за 1 день
(1 отзыв)
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 за 1 день
(1 отзыв)
0.8
€20 EUR за 1 день
(0 отзывов(-а))
0.0
€34 EUR за 1 день
(0 отзывов(-а))
0.0