Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery
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
|SQL Query resolving a string conversion issue||26||38|
|t-sql split string into multiple rows||7||35|
|Trying to export a multi-customer report to separate pdf files by customer||4||16|
|Find missing numbers in Access Table PrimaryKey||9||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!