Refresh Dates

begin declare @ltbl_diff table (valindex integer ,diff integer)

if (db_name () <> 'ShowNovus') begin raiserror ('Only run this script in a "Show" database',0,1) WITH NOWAIT end

begin transaction

---

Accounting_Period

delete @ltbl_diff

raiserror ('Accounting_Period 1 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (month,max (date_from),getdate ()) from Accounting_Period insert @ltbl_diff select 2,datediff (month,max (date_to),getdate ()) from Accounting_Period

update Accounting_Period set date_from = case when date_from is not null then dateadd (month,(select diff from @ltbl_diff where valindex = 1),date_from) else date_from end ,date_to = case when date_to is not null then dateadd (month,(select diff from @ltbl_diff where valindex = 2),date_to) else date_to end ,updated_by = 'date_update' ,updated_on = getdate ()

---

AP_Apply

delete @ltbl_diff

raiserror ('AP_Apply 2 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (applied_date),getdate ()) from AP_Apply

update AP_Apply set applied_date = case when applied_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),applied_date) else applied_date end

---

AP_Cheque

delete @ltbl_diff

raiserror ('AP_Cheque 3 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (cheque_date),getdate ()) from AP_Cheque

update AP_Cheque set cheque_date = case when cheque_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),cheque_date) else cheque_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

AP_Cheque_Detail

delete @ltbl_diff

raiserror ('AP_Cheque_Detail 4 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (document_date),getdate ()) from AP_Cheque_Detail

update AP_Cheque_Detail set document_date = case when document_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),document_date) else document_date end

---

AP_Item

delete @ltbl_diff

raiserror ('AP_Item 5 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (discount_due_date),getdate ()) from AP_Item insert @ltbl_diff select 2,datediff (day,max (document_date),getdate ()) from AP_Item insert @ltbl_diff select 3,datediff (day,max (due_date),getdate ()) from AP_Item

update AP_Item set discount_due_date = case when discount_due_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),discount_due_date) else discount_due_date end ,document_date = case when document_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),document_date) else document_date end ,due_date = case when due_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 3),due_date) else due_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

AR_Apply

delete @ltbl_diff

raiserror ('Accounting_Period 6 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (applied_date),getdate ()) from AR_Apply

update AR_Apply set applied_date = case when applied_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),applied_date) else applied_date end

---

AR_Item

delete @ltbl_diff

raiserror ('AR_Item 7 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (discount_due_date),getdate ()) from AR_Item insert @ltbl_diff select 2,datediff (day,max (document_date),getdate ()) from AR_Item insert @ltbl_diff select 3,datediff (day,max (due_date),getdate ()) from AR_Item insert @ltbl_diff select 4,datediff (day,max (holdback_due_date),getdate ()) from AR_Item

update AR_Item set discount_due_date = case when discount_due_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),discount_due_date) else discount_due_date end ,document_date = case when document_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),document_date) else document_date end ,due_date = case when due_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 3),due_date) else due_date end ,holdback_due_date = case when holdback_due_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 4),holdback_due_date) else holdback_due_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

Firm_Account

delete @ltbl_diff

raiserror ('Firm_Account 8 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (credit_review_date),getdate ()) from Firm_Account;

disable trigger FirmAccountUpdateTrigger on Firm_Account;

update Firm_Account set credit_review_date = case when credit_review_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),credit_review_date) else credit_review_date end ,updated_by = 'date_update' ,updated_on = getdate ();

enable trigger FirmAccountUpdateTrigger on Firm_Account;

---

Foreign_Exchange

delete @ltbl_diff

raiserror ('Foreign_Exchange 9 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (effective_date),getdate ()) from Foreign_Exchange

update Foreign_Exchange set effective_date = case when effective_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),effective_date) else effective_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

GL_Item

delete @ltbl_diff

raiserror ('GL_Item 10 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (transaction_date),getdate ()) from GL_Item

update GL_Item set transaction_date = case when transaction_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),transaction_date) else transaction_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

GL_Journal

delete @ltbl_diff

raiserror ('GL_Journal 11 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (journal_date),getdate ()) from GL_Journal

update GL_Journal set journal_date = case when journal_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),journal_date) else journal_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

GL_Reconciliation

delete @ltbl_diff

raiserror ('GL_Reconciliation 12 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (reconciliation_date),getdate ()) from GL_Reconciliation

update GL_Reconciliation set reconciliation_date = case when reconciliation_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),reconciliation_date) else reconciliation_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

GL_Reconciliation_Detail

delete @ltbl_diff

raiserror ('GL_Reconciliation_Detail 13 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (document_date),getdate ()) from GL_Reconciliation_Detail

update GL_Reconciliation_Detail set document_date = case when document_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),document_date) else document_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

IC_Coil

delete @ltbl_diff

raiserror ('IC_Coil 14 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (received_date),getdate ()) from IC_Coil

update IC_Coil set received_date = case when received_date is null then received_date else dateadd (day,(select diff from @ltbl_diff where valindex = 1),received_date) end ,updated_by = 'date_update' ,updated_on = getdate ()

---

IC_Production_Batch

delete @ltbl_diff

raiserror ('IC_Production_Batch 15 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (batch_date),getdate ()) from IC_Production_Batch

update IC_Production_Batch set batch_date = case when batch_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),batch_date) else batch_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

IC_Production_Order

delete @ltbl_diff

raiserror ('IC_Production_Order 16 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (date_required),getdate ()) from IC_Production_Order insert @ltbl_diff select 2,datediff (day,max (production_order_date),getdate ()) from IC_Production_Order

update IC_Production_Order set date_required = case when date_required is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),date_required) else date_required end ,production_order_date = case when production_order_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),production_order_date) else production_order_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

IC_Ticket

delete @ltbl_diff

raiserror ('IC_Ticket 17 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (ticket_date),getdate ()) from IC_Ticket

update IC_Ticket set ticket_date = case when ticket_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),ticket_date) else ticket_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

Portal_Notification

delete @ltbl_diff

raiserror ('Portal_Notification 18 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (notification_date),getdate ()) from Portal_Notification

update Portal_Notification set notification_date = case when notification_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),notification_date) else notification_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

Portal_Notification_Read

delete @ltbl_diff

raiserror ('Portal_Notification_Read 19 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (read_date),getdate ()) from Portal_Notification_Read

update Portal_Notification_Read set read_date = case when read_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),read_date) else read_date end

---

Print_Job

delete @ltbl_diff

raiserror ('Print_Job 20 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (print_date),getdate ()) from Print_Job insert @ltbl_diff select 2,datediff (day,max (printed_date),getdate ()) from Print_Job

update Print_Job set print_date = case when print_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),print_date) else print_date end ,printed_date = case when printed_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),printed_date) else printed_date end ,updated_by = 'date_update' ,updated_on = getdate ()

---

Product_Ledger

delete @ltbl_diff

raiserror ('Product_Ledger 21 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (transaction_date),getdate ()) from Product_Ledger;

disable trigger ProductLedgerUpdateTrigger on Product_Ledger;

update Product_Ledger set transaction_date = case when transaction_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),transaction_date) else transaction_date end ,updated_by = 'date_update' ,updated_on = getdate ();

enable trigger ProductLedgerUpdateTrigger on Product_Ledger;

---

Product_Log

delete @ltbl_diff

raiserror ('Product_Log 22 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (event_date),getdate ()) from Product_Log;

disable trigger ProductLogUpdateTrigger on Product_Log;

update Product_Log set event_date = case when event_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),event_date) else event_date end ,updated_by = 'date_update' ,updated_on = getdate ();

enable trigger ProductLogUpdateTrigger on Product_Log;

---

Product_Lot

delete @ltbl_diff

raiserror ('Product_Lot 23 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (document_date),getdate ()) from Product_Lot;

update Product_Lot set document_date = case when document_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),document_date) else document_date end

---

Product_Warehouse

delete @ltbl_diff

raiserror ('Product_Warehouse 24 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (last_count_date),getdate ()) from Product_Warehouse; insert @ltbl_diff select 2,datediff (day,max (last_receipt_date),getdate ()) from Product_Warehouse; insert @ltbl_diff select 3,datediff (day,max (last_sales_date),getdate ()) from Product_Warehouse;

disable trigger ProductWarehouseUpdateTrigger on Product_Warehouse;

update Product_Warehouse set last_count_date = case when last_count_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),last_count_date) else last_count_date end ,last_receipt_date = case when last_receipt_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),last_receipt_date) else last_receipt_date end ,last_sales_date = case when last_sales_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 3),last_sales_date) else last_sales_date end ,updated_by = 'date_update' ,updated_on = getdate ();

enable trigger ProductWarehouseUpdateTrigger on Product_Warehouse;

---

Purchase_Order

delete @ltbl_diff

raiserror ('Purchase_Order 25 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (eta_date),getdate ()) from Purchase_Order; insert @ltbl_diff select 2,datediff (day,max (purchase_order_date),getdate ()) from Purchase_Order;

update Purchase_Order set eta_date = case when eta_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),eta_date) else eta_date end ,purchase_order_date = case when purchase_order_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),purchase_order_date) else purchase_order_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

Purchase_Order_Receipt

delete @ltbl_diff

raiserror ('Purchase_Order_Receipt 26 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (invoice_date),getdate ()) from Purchase_Order_Receipt; insert @ltbl_diff select 2,datediff (day,max (packing_slip_date),getdate ()) from Purchase_Order_Receipt; insert @ltbl_diff select 3,datediff (day,max (purchase_order_receipt_date),getdate ()) from Purchase_Order_Receipt;

update Purchase_Order_Receipt set invoice_date = case when invoice_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),invoice_date) else invoice_date end ,packing_slip_date = case when packing_slip_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),packing_slip_date) else packing_slip_date end ,purchase_order_receipt_date = case when purchase_order_receipt_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 3),purchase_order_receipt_date) else purchase_order_receipt_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

Rate_Discount_Period

delete @ltbl_diff

raiserror ('Rate_Discount_Period 27 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (effective_date),getdate ()) from Rate_Discount_Period; insert @ltbl_diff select 2,datediff (day,max (expiry_date),getdate ()) from Rate_Discount_Period; insert @ltbl_diff select 3,datediff (day,max (review_date),getdate ()) from Rate_Discount_Period;

update Rate_Discount_Period set effective_date = case when effective_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),effective_date) else effective_date end ,expiry_date = case when expiry_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),expiry_date) else expiry_date end ,review_date = case when review_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 3),review_date) else review_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

Rate_Period

delete @ltbl_diff

raiserror ('Rate_Period 26 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (effective_date),getdate ()) from Rate_Period; insert @ltbl_diff select 2,datediff (day,max (expiry_date),getdate ()) from Rate_Period; insert @ltbl_diff select 3,datediff (day,max (review_date),getdate ()) from Rate_Period;

update Rate_Period set effective_date = case when effective_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),effective_date) else effective_date end ,expiry_date = case when expiry_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),expiry_date) else expiry_date end ,review_date = case when review_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 3),review_date) else review_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

Sales_Order

delete @ltbl_diff

raiserror ('Sales_Order 29 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (acknowledged_date),getdate ()) from Sales_Order; insert @ltbl_diff select 2,datediff (day,max (completed_date),getdate ()) from Sales_Order; insert @ltbl_diff select 3,datediff (day,max (customer_po_date),getdate ()) from Sales_Order; insert @ltbl_diff select 4,datediff (day,max (delivered_date),getdate ()) from Sales_Order; insert @ltbl_diff select 5,datediff (day,max (earliest_date),getdate ()) from Sales_Order; insert @ltbl_diff select 6,datediff (day,max (estimated_delivery_date),getdate ()) from Sales_Order; insert @ltbl_diff select 7,datediff (day,max (invoice_date),getdate ()) from Sales_Order; insert @ltbl_diff select 8,datediff (day,max (latest_date),getdate ()) from Sales_Order; insert @ltbl_diff select 9,datediff (day,max (order_date),getdate ()) from Sales_Order; insert @ltbl_diff select 10,datediff (day,max (scheduled_date),getdate ()) from Sales_Order; insert @ltbl_diff select 11,datediff (day,max (ship_date),getdate ()) from Sales_Order; insert @ltbl_diff select 12,datediff (day,max (transmitted_date),getdate ()) from Sales_Order;

disable trigger SalesOrderUpdateTrigger on Sales_Order;

update Sales_Order set acknowledged_date = case when acknowledged_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),acknowledged_date) else acknowledged_date end ,completed_date = case when completed_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),completed_date) else completed_date end ,customer_po_date = case when customer_po_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 3),customer_po_date) else customer_po_date end ,delivered_date = case when delivered_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 4),delivered_date) else delivered_date end ,earliest_date = case when earliest_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 5),earliest_date) else earliest_date end ,estimated_delivery_date = case when estimated_delivery_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 6),estimated_delivery_date) else estimated_delivery_date end ,invoice_date = case when invoice_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 7),invoice_date) else invoice_date end ,latest_date = case when latest_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 8),latest_date) else latest_date end ,order_date = case when order_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 9),order_date) else order_date end ,scheduled_date = case when scheduled_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 10),scheduled_date) else scheduled_date end ,ship_date = case when ship_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 11),ship_date) else ship_date end ,transmitted_date = case when transmitted_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 12),transmitted_date) else transmitted_date end ,updated_by = 'date_update' ,updated_on = getdate ();

enable trigger SalesOrderUpdateTrigger on Sales_Order;

---

Sales_Tax

delete @ltbl_diff

raiserror ('Sales_Tax 30 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (effective_date),getdate ()) from Sales_Tax;

update Sales_Tax set effective_date = case when effective_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),effective_date) else effective_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

TA_Sales_Order_Line

delete @ltbl_diff

raiserror ('TA_Sales_Order_Line 31 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (departure_date),getdate ()) from TA_Sales_Order_Line; insert @ltbl_diff select 2,datediff (day,max (policy_date),getdate ()) from TA_Sales_Order_Line; insert @ltbl_diff select 3,datediff (day,max (return_date),getdate ()) from TA_Sales_Order_Line;

update TA_Sales_Order_Line set departure_date = case when departure_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),departure_date) else departure_date end ,policy_date = case when policy_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),policy_date) else policy_date end ,return_date = case when return_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 3),return_date) else return_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

TE_Lot

delete @ltbl_diff

raiserror ('TE_Lot 32 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (permit_request_date),getdate ()) from TE_Lot;

update TE_Lot set permit_request_date = case when permit_request_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),permit_request_date) else permit_request_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

TE_Lot_Billing

delete @ltbl_diff

raiserror ('TE_Lot_Billing 33 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (invoice_date),getdate ()) from TE_Lot_Billing;

update TE_Lot_Billing set invoice_date = case when invoice_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),invoice_date) else invoice_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

TE_Lot_Inspection

delete @ltbl_diff

raiserror ('TE_Lot_Inspection 34 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (inspection_date),getdate ()) from TE_Lot_Inspection; insert @ltbl_diff select 2,datediff (day,max (inspection_request_date),getdate ()) from TE_Lot_Inspection;

update TE_Lot_Inspection set inspection_date = case when inspection_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),inspection_date) else inspection_date end ,inspection_request_date = case when inspection_request_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 2),inspection_request_date) else inspection_request_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

TE_Lot_Inspection_Result

delete @ltbl_diff

raiserror ('TE_Lot_Inspection_Result 35 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (inspection_date),getdate ()) from TE_Lot_Inspection_Result;

update TE_Lot_Inspection_Result set inspection_date = case when inspection_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),inspection_date) else inspection_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

TE_Lot_Option

delete @ltbl_diff

raiserror ('TE_Lot_Option 36 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (invoice_date),getdate ()) from TE_Lot_Option;

update TE_Lot_Option set invoice_date = case when invoice_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),invoice_date) else invoice_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

TE_Lot_PO

delete @ltbl_diff

raiserror ('TE_Lot_PO 37 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (po_date),getdate ()) from TE_Lot_PO;

update TE_Lot_PO set po_date = case when po_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),po_date) else po_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

TE_Model_Billing

delete @ltbl_diff

raiserror ('TE_Model_Billing 28 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (effective_date),getdate ()) from TE_Model_Billing;

update TE_Model_Billing set effective_date = case when effective_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),effective_date) else effective_date end ,updated_by = 'date_update' ,updated_on = getdate ();

---

WD_Quote

delete @ltbl_diff

raiserror ('WD_Quote 39 of 39',0,1) with nowait

insert @ltbl_diff select 1,datediff (day,max (quote_date),getdate ()) from WD_Quote;

update WD_Quote set quote_date = case when quote_date is not null then dateadd (day,(select diff from @ltbl_diff where valindex = 1),quote_date) else quote_date end ,updated_by = 'date_update' ,updated_on = getdate ();

rollback transaction --commit transaction end

Return to Show Database