The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
ALTER TRIGGER [scheme].[metauddel] ON [scheme].[opheadm] AFTER UPDATE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; IF UPDATE (status) declare @Status char(1) declare @OrderNo char (10) declare @OrderLineNo char(1) declare @DateEntered datetime declare @Exist float select @Status = [status]from inserted with (NOLOCK) select @OrderNo = order_no from inserted with (NOLOCK) select @DateEntered = date_entered from inserted with (NOLOCK) if @Status = 9 Begin Insert into opdetm_audit (order_no,order_line_no,line_type,order_line_status,order_qty,despatched_qty,allocated_qty,val) Select order_no, order_line_no, line_type, order_line_status, order_qty, despatched_qty, allocated_qty, val from [scheme].[opdetm]with (NOLOCK) where order_no = @OrderNo and @DateEntered < CAST(FLOOR(CAST(GETDATE() AS FLOAT))AS DATETIME) End END
|Access 2013 - assign the value of an unbounded object to a table value||7||24|
|SQL query and VBA||5||45|
|Comparison query - 4 columns||9||21|
|Reformat SQL - so SSRS can read the columns||25||11|