It is fair to say that I don't do a huge amount of real-time SQL.  As an application developer, the vast majority of SQL I write is in Stored Procedures and packages.  Very infrequently, I need to do a manual insert statement.  So why do I always forget to drop the VALUES keyword in a T-SQL statement when using a sub-query?  I mean every time!

So here it is.  A representative INSERT statement with sub-query:

insert into UserRoleMembership
(userIdx, roleName)
 
(
  select 488, roleName from Roles
  where appidx = 18
  and roleName not in ( select roleName from UserRoleMembership where userIdx = 488 )
)

Now I won't forget.