Completado

Convert Access query with DISTINCTROW in SQL Server query

Este proyecto fue completado exitosamente por angnut por €14 EUR en un día.

Obtén cotizaciones gratis para un proyecto como este
Empleador trabajando
Presupuesto de Proyecto
€8 - €30 EUR
Completado En
1 día
Ofertas Totales
37
Descripción del Proyecto

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

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online