I need to extract from SQL Database, when a scheduled process has ended (date and time).
Does anyone know the name of the SQL table from which I can extract this information?
You are right.
But I've reached the same result with this modified query:
SELECT
Main.Email,
Main.Name,
Main.CompletionDate,
LEFT(Main.Task,Len(Main.Task)-1) As Activity
FROM (
SELECT DISTINCT ST2.Email, ST2.Name, ST2.CompletionDate, (...
Done! But I still have some errors:
USE RPAUF;
SELECT task.[Nome], task., ST2.[Activity], task.[CompletionDate]
FROM [RPAUF].[dbo].[task]
LEFT Join
(SELECT Main.Email,
LEFT(Main.Task,Len(Main.Task)-1) As Activity
FROM
(
SELECT DISTINCT ST2.Email,
(...
A small update. I found a way to solve it but I still need help. The solution can be found using a SQL query that I don't know in deep.
Unfortunately I wrote two separate queries and I need to join both in only one, because the 2nd include all the records and the last row must to be excluded...
Hi,
I've created a process that take data from a database and create a collection like that in fig1.
This data must by taken from Outlook for send emails to those recipients and remind them that the activities must be completed within a certain date.
The process works fine, but Outlook send one...
I have a problem. Starting from a txt file I have to create an excel file ordered on three columns.
The problem is that I have to search for words in a string and, depending on the word, copy the following lines to a different column.
Attached:
1. the txt file
2. the excel blank file
3. the...
Hi,
I'll try to explain it. Appian is a platform of Business Process Management. Means that with Appian you can realize Business Processes managed by humans. Appian has a strong partnership with Blue Prism, where as you know, you can develop unattended processes.
So, for example, you can realize...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.