We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
CREATE TRIGGER Shipping_Audit_Trg ON Products ---Product table is primary table FOR UPDATE, INSERT AS UPDATE ProductAudit ---- ProductAudit table is to contain information related to shipment, returns. itemid, memberid, productid SET ShippedDate = GETDATE() ---- I want to pull the date that is inserted into the Product table ---SET returneDate = GETDATE() --- I also want to pull the date for any returns if this field is updated FROM inserted as i INNER JOIN ProductAudit as pa on pa.orderID = i.orderID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Running total between 2 sql tables in Sql||6||50|
|Using rowversion for incremental load of datawarehouse.||12||35|
|SQL Server how to use a VARIABLE to link tables in a SQL Script?||3||41|
|SQL - Result of a formula to decimal (not integer) value||7||22|
Join the community of 500,000 technology professionals and ask your questions.