StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<pre><code>SELECT CASE WHEN ( SELECT MIN(date_created) FROM ( SELECT date_created FROM table1 UNION ALL SELECT date_created FROM table2 UNION ALL SELECT date_created FROM table3 ) q ) >= ( SELECT MIN(date_created) FROM table4 ) THEN 1 ELSE 0 END </code></pre> <p><strong>Update</strong></p> <pre><code>SET LANGUAGE ENGLISH DECLARE @table1 TABLE (date_created DATETIME) DECLARE @table2 TABLE (date_created DATETIME) DECLARE @table3 TABLE (date_created DATETIME) DECLARE @table4 TABLE (date_created DATETIME) INSERT INTO @table1 VALUES ('1991-10-24 00:00:00.000') INSERT INTO @table1 VALUES ('1995-08-03 00:00:00.000') INSERT INTO @table1 VALUES ('1990-01-03 00:00:00.000') INSERT INTO @table1 VALUES ('2000-12-31 00:00:00.000') INSERT INTO @table1 VALUES ('2000-12-31 00:00:00.000') INSERT INTO @table1 VALUES ('2000-02-08 00:00:00.000') INSERT INTO @table1 VALUES ('2002-07-03 00:00:00.000') INSERT INTO @table1 VALUES ('1999-01-06 00:00:00.000') INSERT INTO @table2 VALUES ('2007-02-02 00:40:30.823') INSERT INTO @table3 VALUES ('2006-09-23 01:13:15.530') INSERT INTO @table4 VALUES ('2006-05-31 00:00:00.000') SELECT CASE WHEN ( SELECT MIN(date_created) FROM ( SELECT date_created FROM @table1 UNION ALL SELECT date_created FROM @table2 UNION ALL SELECT date_created FROM @table3 ) q ) >= ( SELECT MIN(date_created) FROM @table4 ) THEN 1 ELSE 0 END DELETE @table1 DELETE @table2 DELETE @table3 DELETE @table4 INSERT INTO @table1 VALUES ('2007-11-29 00:00:00.000') INSERT INTO @table1 VALUES ('2007-08-17 00:00:00.000') INSERT INTO @table1 VALUES ('2005-12-06 00:00:00.000') INSERT INTO @table1 VALUES ('2007-05-04 00:00:00.000') INSERT INTO @table1 VALUES ('2006-08-07 00:00:00.000') INSERT INTO @table1 VALUES ('2007-06-13 00:00:00.000') INSERT INTO @table3 VALUES ('2006-06-08 02:08:07.253') INSERT INTO @table3 VALUES ('2006-06-08 02:08:07.253') INSERT INTO @table4 VALUES ('2001-05-31 00:00:00.000') INSERT INTO @table4 VALUES ('2000-05-31 00:00:00.000') SELECT CASE WHEN ( SELECT MIN(date_created) FROM ( SELECT date_created FROM @table1 UNION ALL SELECT date_created FROM @table2 UNION ALL SELECT date_created FROM @table3 ) q ) >= ( SELECT MIN(date_created) FROM @table4 ) THEN 1 ELSE 0 END </code></pre> <p>The two queries returns <code>0</code> and <code>1</code>, exactly as they should.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload