Database

You'll have to do some code unless you want to only demo features that don't require any code. There are two kinds of people in the world: those who can extrapolate from incomplete data. There are only 10 types of people in the world, those who understand binary and those who don't.

Thanks. A very nice concept, I definitely want to try that.

Which database engine? Are the databases on the same server?

If you have a logging system, then you can easily check which jobs are running and which failed due to what, in the logs. There are a lot of good articles and tips, that can help you understand how to fix the jobs based on the logging data. If you have no logs, then it will be more difficult to understand what is going wrong and where. Also the following threads show you with a good way to get the failed SQL jobs, [sql server - What is the Query to display the failed sql jobs - Database Administrators Stack Exchange](http://dba.stackexchange.com/questions/88810/what-is-the-query-to-display-the-failed-sql-jobs), [How to obtain failed jobs from sql server agent through script? - Stack Overflow](http://stackoverflow.com/questions/10577676/how-to-obtain-failed-jobs-from-sql-server-agent-through-script) [Semi-Advanced Logging Options for SQL Server Agent Jobs | Practical SQL Server](http://sqlmag.com/blog/semi-advanced-logging-options-sql-server-agent-jobs) [sql server - Get detailed output of SQL Agent job - Database Administrators Stack Exchange](http://dba.stackexchange.com/questions/95333/get-detailed-output-of-sql-agent-job) [SQL Server Agent Error Log | Microsoft Docs](https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-error-log) [How to debug jobs?](https://www.sqlservercentral.com/Forums/Topic1094893-391-1.aspx) Or even better would be to simply use the SQL Server Agent Jobs. The following will help on this, [How to: Create a SQL Server Agent Job (Transact-SQL)](https://technet.microsoft.com/en-us/library/ms181153(v=sql.105).aspx) [Create a Job | Microsoft Docs](https://docs.microsoft.com/en-us/sql/ssms/agent/create-a-job) The shit I complain about It's like there ain't a cloud in the sky and it's raining out - Eminem ~! Firewall !~

Mycroft Holmes wrote: no longer supported in current browsers It's not dead yet, but it's not looking too healthy. :) "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

See Saving Data in SQL Databases | Android Developers[^] and SQLite Home Page[^].

Richard, Worked a treat, thank you. I've trawled the sites looking for a solution but didn't come across the CALL keyword - so very frustrating. On a side note, from a performance perspective, is there a better way of this being implemented? The solution could take a large throughput and I'm keen to understand any improvements. Again, thanks for the tip. JMY.

Every column in a view needs to have a unique name. You've given all four columns the alias "a", which is obviously not unique. Just remove the four As a alias from the SELECT part of the query, and you should be able to create a view. SELECT DISTINCT b.event_id, b.user_ID, b.date, b.Time FROM quadrantids2017 AS a JOIN quadrantids2017 AS b WHERE a.`date` = b.`date` AND a.user_ID != b.user_ID AND time_to_sec(a.`Time`) - time_to_sec(b.`Time`) BETWEEN -30 AND 30 Alternatively, give each column a unique alias. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

spoke to soon, there are duplicates 37919 2 2017-01-01 11:43:02 37920 2 2017-01-01 11:43:23 47890 3 2017-01-01 11:42:56 47890 3 2017-01-01 11:42:56 47894 3 2017-01-01 12:13:31 33558 1 2017-01-01 12:13:29 47896 3 2017-01-01 13:24:44 37937 2 2017-01-01 13:24:17 37945 2 2017-01-01 14:09:53 37945 2 2017-01-01 14:09:53 sorry

Thank You - Appreciated

You're welcome :) Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Thanks again to give me some confidence on this

Yogi S. wrote: So how FB is doing this? What database actually FACEBOOK uses?[^] Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

I think the width was 74, just not sure 74 of what unit. If it ain't broke don't fix it

Jörgen Andersson wrote: Yes, this would probably be the right way of doing it. :sigh: Not the most exciting thing to do, I agree :thumbsup: Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Thanks appreciated :) .