Convert Access query with DISTINCTROW in SQL Server query
€8-30 EUR
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")
Project ID: #11756345
About the project
Awarded to:
Provato con DISTINCT? Try with DISTINCT Contattami per maggiori info. Please share me more details More info: [login to view URL] Ciao Angelo
32 freelancers are bidding on average €21 for this job
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
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
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
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.
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.
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
My expertise in SQl and I have worked on similar queries earlier previously. Hoping to get some more projects like this
I am experienced in SQL Server and T-SQL. I understand the requirement of the project and can do as needed. Thank you.
Hello, I'm expert to query SQL Server. I can help you convert this query to SQL Server. =================================================
I have a good knowledge of SQL and can correct this SQL in minutes. Please provide me the opportunity to prove myself.
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.
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.
BID PROPOSAL: The proposal details are mentioned below: The final bid amount is 12 Euros ETA - 1 day