February 8, 2006 at 8:24 am
I'm working on an billing application, where I have two tables one contains the Project Manager table which contains the detail of a person and to what project he is PM. These PM can designate people as Proxy.
The PM table is refreshed data from other database source viz SAP and the Proxy PM table gets updated when the PM allocate Proxy for the project using the application.
The above is the setup and now i face a constraint that a person cannot be a PM and a Proxy PM for the same project. I tell u an scenario, when a person already existing as ProxyPM is designated as PM (by making changes in SAP) and when an entry is made against the same project code, the entry for the same should be deleted from the Proxy PM table.
In case if you need the fileds that are in the table is
ProjectManager Table: (which gets updated from other source)
Emp# Projectcode PMEmp#
ProxyPM Table : (which gets data from the application) it has the same fields as the ProjectManager table.
February 8, 2006 at 11:08 am
Can you give a small example with pseudo values?
DELETE ProxyPM
FROM ProxyPM
INNER JOIN PM
ON PM.PMEmp=ProxyPM.PMEmp /*same project manager*/
AND PM.Projectcode=ProxyPM.Projectcode /*same project*/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply