Probably several ways of doing that, but this one will work:

WITH a (aval, astamp) AS (

SELECT min(value), min(t_stamp) from @t

WHERE value = (SELECT min(value) FROM @t)

)

, b (bval, bstamp) AS...

Could it be because you have ">=" in the first and ">" in the second?

John

Because NULL means "unknown" and therefore "NULL not equal to 'Check' " can't equate to True.

John

Because you're looking for those students who have a match with every row in tblData. Therefore the row count for each student needs to be the same as the...

You tell me. Is it returning the results you expected? If it is, then your requirement has changed, because you said you only...

Here you go. Obviously it doesn't return any rows for your sample data, but if it did, you could join back to A if you need the student name.

John

SELECT

B.StudentID

FROM

B

JOIN

TblData...

Join @tblData to TableB, group by StudentID, and return those rows having count(*) equal to the number of rows in @tblData. Without full DDL and sample data, I can't...

No, it doesn't. It means that backup tasks were the only activity that was written to...

Only if you had a particular trace flag enabled at the time the deadlocks occurred.

http://www.sqlservercentral.com/articles/deadlocks/74829/%5B/url%5D

John

If you don't have any monitoring system set up that captures those events, then you can't do it. It may be worth looking in the default trace, but I'm...

Beware that if you have more than one data file in your database, your query will fail.

John

I can't find it documented anywhere, and I don't know whether there are any exceptions, but it looks like you need to build your parameter value in advance. Probably...

Well, you certainly need to lose the first and last quotation marks in the @Directory line. Even then, you might still not be allowed to concatenate in place, so...

There are utilities that enable you to mount a backup file as a database without actually restoring it. So you could back up your live database, then mount the...

SQL Server will attempt to resolve all objects except those that it can determine will NEVER be necessary to return results when it parses the query. Otherwise it will attempt...