I am sorry, I don't use SQL too much.. Here it is -
![]()
USE [ZZ_Common] GO /******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Update_Vol] AS BEGIN SET NOCOUNT ON; update XR..VolSurf with (rowlock)set LastVolUpdated_At = GETDATE() update XR.. VolSurf_Sales with (rowlock) set LastVolUpdated_At = GETDATE(),Published_At = GETDATE() update XR.. VolSurfSmile with (rowlock) set LastVolUpdated_At = GETDATE(),Published_At = GETDATE() END
Bookmarks