With Customers as(

select
        Customer_name,
        Account_number,
        cast (Purchase_date as date) AS DateofPurchase,
        Subscription_type
        Amount        
from table_a
where Customer_name != 'Test'...

Thanks guys!

Both suggestions have been insightful!

thanks again for the help

always appreciated

Apologies,

So currently there is an infopath which is submitted to a sql table.

I have built a trigger to send an email based on certain conditions being met.

The...

Thanks for the comprehensive reply.

After much deliberation, it has been brought to my attention that the organisation I work for will not allow access to SSRS so I am stuck...

Hello Guys,

Thanks for providing the code to include a image withing the emails.

I am fairly new to SQL and how to use a email functions within SQL server, not...