Slightly confused by your requirements based on the data.  For September you are asking for data from July?  Date entered is 9-12-2007, data returned is for 7-1-2007 - 7-31-2007?

gova, so that's why i had trouble using STUFF when I was trying to come up with a conversion solution.  Thanks!

When trying to convert the character value '30122006', sql is expecting the value to represented in the format yyyymmdd.  I tried your sample and got the same error.  adding the...

Works fine for me also.

If I understand the licensing properly, you will need to purchase SQL Server using per procosser licensing.  Use of multiplexing does not reduce the requirements, you have to base it...

The above mentioned KB was very helpful in identifying my data issues and helping me correct them.

I already found a KB articule that should help me, thanks.

KB: http://support.microsoft.com/kb/923247

You indicate that the insert trigger works, how about the others?  If all is fine, I think you have successfully done what you set out to do.

Have you tested these triggers in a development environment?

The next question, is there a possibility of more than one record being inserted/updated/deleted at a time from the application?

Would you please provide the complete DDL for the trigger?

So, you are asking us on this forum to write your triggers for you instead of writing them yourself?  I'd like to see what you have tried to come up...

Going off-line, check your private messages.

Professionalism, sometimes we exhibit it, some times we don't (been there done that; didn't mean much by it but it blew things out of proportion).  You can stupe (sp ?)...

Could we see what you have done already in this regard?

What is the error message you are getting?  That may help diagnosis your problem.