This the final script , i need the paths to be selected from table for example :

declare @path = (Select Description from Lookup where code ='XML Path';

then i need to...

Thank you very much

amazing, two things and will not ask again " Sorry "

1- How read XML from local drive

2- Timestamp is datetime how to format it into two column one for date...

How can i read XML from path , then table retrive as below :

rate Type - rate Timestamp - Type - rate Name - rate type - Buy - sell

The problem that i don't know from where to start, i need to have table to store the data

Thank you it's working, but let me ask if this will work for any number of records ?

Thanks 🙂 , this is exactly what i want

i already got the error , but i need to store this values in a view

Thank you so match go answer for me

It's work fine with my company domain and now with our exchange and i can send it's very good, but my question what if i want to change the smtp...

i think there is a clarion template can collect all tps tables in one script

see the attached

i think after you add this template open the application and press Ctrl...

so noway to setup database mail with hotmail or yahoo to send from them ? that's because i have to answer my team

DECLARE @tableHTML NVARCHAR(MAX) ;

SET @tableHTML =

N' ' +

N' ' +

N' ' +

N' '...

check the following example i used it and it works fine but dont forget to enable ( database mail )

------------

DECLARE @tableHTML NVARCHAR(MAX) ;

SET @tableHTML...

what kind of data you want to send, i have a full document for this point ( send email by database mail ) via procedure, what i have now...