In Progress

Hire sql developer

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.

Skills: SQL

See more: sql programming jobs salary, sql query cost, sql programmer job description, sql developer explain plan cost, freelance sql server developer, sql programmers, how much to charge for access database, custom database design pricing, sql developer to hire, sql developer for hire dallas tx, my client a young fintech company in dublin 2 are now looking to hire an experienced ms sql developer on a permanent basis with, india hire sql developer, how much does it cost to hire a sql developer, hire sql developer online, hire sql developer

About the Employer:
( 0 reviews ) Greece

Project ID: #15539892

Awarded to:


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 More

€30 EUR in 3 days
(13 Reviews)

4 freelancers are bidding on average €48 for this job


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 More

€111 EUR in 2 days
(1 Review)
€23 EUR in 1 day
(0 Reviews)
€29 EUR in 1 day
(0 Reviews)