Hire sql developer

V teku Objavljeno pred 6 letoma/leti Plačilo ob prevzemu

€8-30 EUR

Plačilo ob prevzemu

V teku Plačilo ob prevzemu

We need a query which will send email's from our server sql2008 .

The email should be in HTML format, send email's to different receipients with data from a view in our Database.

We have the query which contains data like:

email1@[url removed, login to view]

Invoice number | Amount

A123 | 500 Euro

A124 | 120 Euro

email2@[url removed, login to view]

Invoice number | Amount

A132 | 300 Euro

A136 | 220 Euro

Our clients should only receive their information, so our client with email address should receive only the table with A123 and A124 invoice.

It should be someting like the attached picture.

We already have a profile in our database to send emails, but we don't know how to build this query.

We tried to do it using the msdb.dbo.sp_send_dbmail but with no success until now.

SQL

ID projekta: #15539892

Več o projektu

4 predlogov Oddaljen projekt Aktiven pred 6 letoma/leti

Želiš zaslužiti nekaj denarja?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Bodi plačan/a za svoje delo
Oriši svojo ponudbo
Vpis in prijave na dela so brezplačni

Dodeljeno:

Profilna slika desconit
desconit

According to project description you want to send customized emails to clients which will contain information specific to a particular client, Relevant Skills and Experience I have 12 years of experience in database d Več

€30 EUR v 3 dneh
(13 mnenj)
4.3

4 freelancerjev ponuja v povprečju za €48 na tem delu

Profilna slika ShraveeSoftwares
ShraveeSoftwares

Dear Sir, Thank you for posting this interesting project. It seems your server does not have mail server setup or has config issue. I had used sp_send_dbmail few years back for one of the project. Stay tuned, I'm st Več

€111 EUR v 2 dneh
(1 Ocena)
1.5
Objavi podoben projekt