Convert Access query with DISTINCTROW in SQL Server query

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

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

SELECT DISTINCTROW

[login to view URL],

[login to view URL],

[login to view URL] AS IIBDCD,

[login to view URL] AS IIBHNB,

[login to view URL] AS IIBINB,

[login to view URL] AS AnaUnica,

[login to view URL] AS IIP6CD,

[login to view URL] AS IIP8CD,

[login to view URL] AS IIAANR,

[login to view URL] AS IIAFNR,

[login to view URL] AS IISXST,

[login to view URL],

[login to view URL],

[login to view URL] AS IIAGST

INTO [005- Contributi >1993]

FROM

TABLE_A,

TABLE_B

INNER JOIN

TABLE_C

ON ([login to view URL] = [login to view URL])

AND ([login to view URL] = [login to view URL])

WHERE

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

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

Database Programming Microsoft SQL Server SQL

Project ID: #11756345

About the project

32 proposals Remote project Active 7 years ago

Awarded to:

angnut

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

€14 EUR in 1 day
(20 Reviews)
4.2

32 freelancers are bidding on average €21 for this job

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
(77 Reviews)
6.4
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
(12 Reviews)
5.3
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
(22 Reviews)
4.7
dat2na

Greetings, I'm professional database expert with 8+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like More

€34 EUR in 1 day
(4 Reviews)
4.4
dekinghtg

A proposal has not yet been provided

€30 EUR in 1 day
(8 Reviews)
3.7
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
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
(3 Reviews)
2.6
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
(2 Reviews)
2.3
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
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.5
donka92

I`ve been working as a datawarehouse developer for the past 2 years. I work mainly with oracle pl/sql developer as I create tens of functions, procedures and queries on regular basis. I believe I am the candidate you a More

€23 EUR in 1 day
(0 Reviews)
0.0
shwetagupta1991

My expertise in SQl and I have worked on similar queries earlier previously. Hoping to get some more projects like this

€19 EUR in 1 day
(0 Reviews)
0.0
aorlivska

Hello! My name is Oleksandra and I’m an IT manager at ServerSupport.pro. I work in a team of specialists with 8+ years of experience in System Administration. Your project is quite interesting and our team c More

€26 EUR in 1 day
(0 Reviews)
0.0
prashantkprabhat

I am experienced in SQL Server and T-SQL. I understand the requirement of the project and can do as needed. Thank you.

€23 EUR in 1 day
(0 Reviews)
0.0
hoconghoai

Hello, I'm expert to query SQL Server. I can help you convert this query to SQL Server. =================================================

€13 EUR in 1 day
(0 Reviews)
0.0
nehagarg511

I have a good knowledge of SQL and can correct this SQL in minutes. Please provide me the opportunity to prove myself.

€8 EUR in 1 day
(0 Reviews)
0.0
geetumishra76

I have an indepth knowlwdge of database and have worked on this technology for 12 years. I have worked as an Architecture in SQL Server, so i think i can give full justice to your query.

€24 EUR in 1 day
(0 Reviews)
0.0
nikpren

Dear employer, I have read the details of your job and I believe I am a great fit. Please take a look at my profile to see my achievements. We can discuss further over chat. Thank you.

€23 EUR in 1 day
(0 Reviews)
0.0
Ragav38

BID PROPOSAL: The proposal details are mentioned below: The final bid amount is 12 Euros ETA - 1 day

€12 EUR in 1 day
(0 Reviews)
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 More

€8 EUR in 1 day
(0 Reviews)
0.0