Find Jobs
Hire Freelancers

Extract data with MS Access and SQL

$10-30 USD

In corso
Pubblicato più di 7 anni fa

$10-30 USD

Pagato al completamento
I want to extract data from my MSSQL-database which is linked with ODBC to MS Access. I have done a task in MS-access that extracts the data I want but when there is no EAN linked to the product the product doesnt show up in the list. I would like to collect both products with ean and products without ean. Can you help me to change the sql-question? "SELECT [login to view URL] AS ID, "0" AS [Active(0/1)], [login to view URL] AS Name, [login to view URL] AS [Price tax excluded or Price tax included], 53 AS [Tax rules ID], [login to view URL] AS [Wholesale price], "" AS [On Sale], "" AS [Discount amount], "" AS [Discount percent], "" AS [Discount from (yyyy-mm-dd)], "" AS [Discount to (yyyy-mm-dd)], [login to view URL] AS [Reference #], [login to view URL] AS [Supplier reference #], [login to view URL], [login to view URL] AS Manufacturer, First([login to view URL]) AS EAN13, 0 AS ECOTAX, [login to view URL] AS Weight, [login to view URL] AS [Product creation date], 1 AS [Available for order (0 = No, 1 = Yes)], 1 AS [Show price (0 = No, 1 = Yes)], 1 AS [ID / Name of shop], "new" AS Condition, [login to view URL], [login to view URL], [login to view URL] FROM dbo_ARTIKLAR_EAN INNER JOIN ((dbo_ARTIKLAR INNER JOIN dbo_ARTIKLAR_INKOP ON [login to view URL] = [login to view URL]) INNER JOIN dbo_LEVERANTORER ON [login to view URL] = [login to view URL]) ON [login to view URL] = [login to view URL] GROUP BY [login to view URL], "0", [login to view URL], [login to view URL], 53, [login to view URL], "", "", "", "", "", [login to view URL], [login to view URL], [login to view URL], [login to view URL], 0, [login to view URL], [login to view URL], 1, 1, 1, "new", [login to view URL], [login to view URL], [login to view URL], [login to view URL] HAVING ((([login to view URL]) Not Like "V*") AND (([login to view URL])=1) AND (([login to view URL])=1) AND (([login to view URL]) Like "036" Or ([login to view URL]) Like "BRIGGS" Or ([login to view URL]) Like "180" Or ([login to view URL]) Like "5562878164" Or ([login to view URL]) Like "1004" Or ([login to view URL]) Like "1010" Or ([login to view URL]) Like "JOFRAB" Or ([login to view URL]) Like "1061" Or ([login to view URL]) Like "5567099253" Or ([login to view URL]) Like "STIGA" Or ([login to view URL]) Like "EINHELL" Or ([login to view URL]) Like "OREGON" Or ([login to view URL]) Like "SWED") AND (([login to view URL])=1)) ORDER BY [login to view URL];"
Rif. progetto: 11842120

Info sul progetto

8 proposte
Progetto a distanza
Attivo 8 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
I have already the solution. You have to do a little change to your query. I can give you the correct version after the confirmation of the bid.
$20 USD in 0 giorno
5,0 (1 valutazione)
0,7
0,7
8 freelance hanno fatto un'offerta media di $27 USD
Avatar dell'utente
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$24 USD in 1 giorno
4,9 (63 valutazioni)
6,9
6,9
Avatar dell'utente
Dear Client, Yes, there is issue with joins. It can be easily corrected. Thank you, Regards, Havit
$30 USD in 1 giorno
5,0 (6 valutazioni)
5,3
5,3
Avatar dell'utente
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$30 USD in 3 giorni
4,9 (15 valutazioni)
3,7
3,7
Avatar dell'utente
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$30 USD in 0 giorno
4,8 (11 valutazioni)
3,5
3,5
Avatar dell'utente
A proposal has not yet been provided
$30 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
hello, Dear Revered, we are the company who work for your benefit. we are the company where work comes first rather then anything else. Please provide me a chance to discuss about this project. we will provide you with the best possible work where what you say, is what we do. thanking you. kind regards.
$25 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A can assist and have lots of Access, SQL and data migration techniques. There are several ways to solve your problem and perhaps enhance like auto generating your own EAN or just modify the query.
$25 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements.i have right skills to work on this assignment my award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. can u provide your email or sky-pe etc for further discussion about the project. I am ready to discuss with you with best Regards
$23 USD in 6 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: SWEDEN
Tyresö, Sweden
5,0
4
Metodo di pagamento verificato
Membro dal lug 29, 2016

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.