Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pxh12
  • Order by date
  1. pxh12

    Problem with datetime in trigger

    Hi SQLSister, I'll concede to the better advice given here and rewrite the trigger to handle multiple rows once I've solved this problem. DW_PR_REALIZATION_DATE is a datetime in its table. The data is validated in the application so only a datetime can be entered. I have tried doing using an...
  2. pxh12

    Problem with datetime in trigger

    Hi gmmastros, Thanks for your reply. The application only allows one row to be updated at a time, so there is no need to handle multiple row updates.
  3. pxh12

    Problem with datetime in trigger

    Hi, I'm trying to write a trigger that will create a record in a table when a value is changed. When I fire the trigger, I get this error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value The problem lies in the passing of a date to a...
  4. pxh12

    Create Outlook Task from SQL Trigger

    Hi, bit of a long shot here. I need to be able to create/delete tasks on users exchange mailboxes from SQL2005 when certain triggers are fired. I have a table containing a list of tasks allocated to different employees. Columns are as follows: TaskID - Unique Task ID (PK) TaskEmployeeID -...

Part and Inventory Search

Back
Top