Viewing 15 posts - 25,546 through 25,560 (of 26,487 total)
try:
exec xp_cmdshell 'telnet aukebper.dc-dublin.de 1521'
![]()
August 16, 2007 at 9:36 am
Can you post the DDL for the table, the query you are running, and some sample data?
![]()
August 16, 2007 at 9:34 am
DECLARE
@myTable TABLE
(
DataDate
DATETIME,
DataVale
INT
)
INSERT
@myTable
SELECT
August 16, 2007 at 9:23 am
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?
August 16, 2007 at 9:16 am
gova, so that's why i had trouble using STUFF when I was trying to come up with a conversion solution. Thanks!
![]()
August 16, 2007 at 9:12 am
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...
August 16, 2007 at 8:28 am
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...
August 16, 2007 at 7:58 am
The above mentioned KB was very helpful in identifying my data issues and helping me correct them.
![]()
August 15, 2007 at 1:49 pm
I already found a KB articule that should help me, thanks.
KB: http://support.microsoft.com/kb/923247
![]()
August 15, 2007 at 10:06 am
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.
August 15, 2007 at 9:54 am
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?
August 15, 2007 at 9:14 am
Would you please provide the complete DDL for the trigger?
![]()
August 14, 2007 at 4:32 pm
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...
August 14, 2007 at 2:50 pm
Going off-line, check your private messages.
August 14, 2007 at 2:04 pm
Viewing 15 posts - 25,546 through 25,560 (of 26,487 total)