I would lke to Insert Into Secured: 0, LogDate,Messages. I'm currently doing this with 2 statements; Insert, then Update(not shown). I'm always looking for a shorter way to code.
[Current Insert NOT working!]
Insert Into Secured (IsDone,LogDate,Messages)
0, (Select convert(varchar,convert(datetime,LogDate),22),Messages
GROUP By LogDate,Messages)