It looks like you are referencing the same table more than once and you have a few columns that you haven't defined which table they come from.  In your Group by...

It's basically the same as this...

convert(int,substring(convert(binary(4), @@microsoftversion),1,1))

@@MicrosoftVersion give what versoin of the engine you are using.  for me its 8 because I use 2000. for 2005 it's 9.  Not...

If ClaimNumber does not exist in GE_Reserve, why would you have it in your select list? 

Are you joining to another table so that you can insert claimnumber?  If it...

Are the dates always surrounded by '--'  If so you could look for the -- followed by a 'by' and use that as a way to get your string date.  Convert...

Any chance you could post some more info for us?  How about, your SQL statements to do you updates as well as table design for starters...  Take a look at...

From what I can gather he was just dropping the time portion off so that when he displayed it on the page he could just show the date.  Unfortunately, since...

That's exactly what I was looking for... I knew there was somethigng silly I was over looking.

Absolutely, for some reason I was thinking that Full backups truncated the log as well... Oh well.  That's what happens when your fingers get out in front of your brain......

As lynn stated, you can change the recovery level of your database, just know that if you are not using full recovery you lose the ability to do a point...

Here's my feeling on transaction logs and there are those out there who may disagree...

I do full, differential and transaction log backups at regular intervals...

If I go through the trouble...

Per BOL(backup)

LOG

Specifies a backup of the transaction log only. The log is backed up from the last successfully executed LOG backup to the current end of the log. Once...