Database

swguy23 wrote:

so I want to use NOT IN query. How can i use it.

SELECT *
FROM MyTable
WHERE id NOT IN(1, 3, 5, 7, 13, 17)

UPDATE JSCvs SET LastUpdated = GETDATE()<br />
WHERE UID = (SELECT UID FROM INSERTED)

select distinct s.Sender_FName,s.Sender_LName, max(s.createdate) as recent_date, 1 AS User_Flag
from tblSender s
group by s.Sender_FName,s.Sender_LName
order by s.Sender_LName,s.Sender_FName

UPDATE
    tblSender 
SET
    User_Flag = 1
WHERE
    createdate = (SELECT 
                      MAX(s.createdate)
                  FROM
                      tblSender s
                  WHERE
                      s.Sender_FName = tblSender.Sender_FName AND
                      s.Sender_LName = tblSender.Sender_LName)