What version of SQL Server are you running?

Actually, your expected results didn't clearly detail what you were looking for so I guessed.

Check this, is this what you were looking for?

DECLARE @myTable TABLE

(

DataDate DATETIME,

DataVale INT

)

INSERT @myTable

SELECT '07/01/2007', 100...

Use my first query.

try:

exec xp_cmdshell 'telnet aukebper.dc-dublin.de 1521'

Can you post the DDL for the table, the query you are running, and some sample data?

DECLARE

@myTable TABLE

(

DataDate

DATETIME,

DataVale

INT

)

INSERT

@myTable

SELECT

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?