Dear Sir or Madam,
I have the following SQL queries that I need to schedule to run every night via SQL Enterprise Manager. Would you please provide me an advise how is the best way to do it? I appreciate your help in advance.
Jimmy
UPDATE gltran
SET gltran.user1 = apdoc.user1
FROM dbo.APDoc INNER JOIN
dbo.GLTran ON dbo.APDoc.RefNbr = dbo.GLTran.RefNbr
WHERE (dbo.GLTran.[Module] = 'AP') and Left
(gltran.acct,3)= '731' ;
UPDATE gltran
SET gltran.user3 = apdoc.user5
FROM dbo.APDoc INNER JOIN
dbo.GLTran ON dbo.APDoc.RefNbr = dbo.GLTran.RefNbr
WHERE (dbo.GLTran.[Module] = 'AP') and Left
(gltran.acct,3)= '731'
Thanks
Jimmy
I have the following SQL queries that I need to schedule to run every night via SQL Enterprise Manager. Would you please provide me an advise how is the best way to do it? I appreciate your help in advance.
Jimmy
UPDATE gltran
SET gltran.user1 = apdoc.user1
FROM dbo.APDoc INNER JOIN
dbo.GLTran ON dbo.APDoc.RefNbr = dbo.GLTran.RefNbr
WHERE (dbo.GLTran.[Module] = 'AP') and Left
(gltran.acct,3)= '731' ;
UPDATE gltran
SET gltran.user3 = apdoc.user5
FROM dbo.APDoc INNER JOIN
dbo.GLTran ON dbo.APDoc.RefNbr = dbo.GLTran.RefNbr
WHERE (dbo.GLTran.[Module] = 'AP') and Left
(gltran.acct,3)= '731'
Thanks
Jimmy