Database

select teamId
from orgTeams
left join orgUsers
on teamID = userTeamId
where userTeamId IS NULL

UPDATE T1
SET time2 = T2.time2
FROM T2
WHERE T1.id = T2.id

SELECT *
FROM tblFullTextSearch
WHERE fldPublicationDate >= '19950101' AND fldPublicationDate < '19960101'

DECLARE @Mth AS Varchar(5)
DECLARE @Yr AS Varchar(5)
SET @Mth = '5'
SET @Yr = '2007'
SELECT * FROM TblA order by id
SELECT a.*
FROM TblA a 
   INNER JOIN (SELECT id, Max(Edate) AS Edate FROM TblA WHERE Edate < @mth + '/01/' + @yr GROUP BY id)b
                           ON a.id = b.id AND a.Edate = b.Edate
ORDER BY a.id

SELECT a.* 
FROM a 
   INNER JOIN (SELECT id, Max(edt) AS edt FROM a GROUP BY id)b 
                           ON a.id = b.id AND a.edt = b.edt
ORDER BY a.id

DECLARE @nth as bigint
SET @nth = 10

SELECT * 
FROM TblA AS a 
WHERE @nth = (SELECT COUNT(ColA) 
              FROM TblB AS b 
              WHERE b.ColA >= a.ColA)