Just be mindful of the possible surprise such a change could cause if the departure data has a midnight time.

Oddly enough, I was going to suggest Triangular Joins.  I decided not to because I don't...

There might be!!! Did you try what I...

Despite your thoughts, you're still concatenating the table name  without checking to see...

Like I said in a different post, new versions of SQL Server scare...

If you wanted to be absolutely sure, you could change what is captured in the error log to log both successful and unsuccessful logins and then bounce the service to...

Awesome!  Looking forward to seeing it, John!

What do you get when you write it with straight criteria instead of selecting from the sub-query?

Of course, that recommendation also comes with the warning that if the hashbytes are different, then the rows are guaranteed to be different.  However (and you know this...

• This reply was modified 6 years, 4 months ago by Jeff Moden.

SELECT CONCAT('
SELECT ''', QUOTENAME(t.TABLE_SCHEMA), '.', QUOTENAME(t.TABLE_NAME),  ''' [TABLE_NAME], COUNT(*) COUNT 
  FROM (SELECT ',x.c, '
         ...

well the PK alone doesn't indicate real world duplicates as in you can create an index column of sorts but that doesn't solve potential duplicates and even where there...

Why do you need to do this?  Any table with a unique index on it, even a non-clustered one, will not have duplicates in it.  Same goes for any table...

Look in the upper right corner of the display for "Write for us".  Click and follow your nose.

Duplicate post.  Please... no posts here.  No need to split up possible answers.  Go to the first one in process at https://www.sqlservercentral.com/forums/topic/audit-failed-successful-login-log-4#post-3709164

Duplicate post.  Please... no posts here.  No need to split up possible answers.  Go to the first one in process at https://www.sqlservercentral.com/forums/topic/audit-failed-successful-login-log-4#post-3709164