Hi I'm developing an ASP app to be the new front end to an existing SQL Server
DB. The db lists Exhibitions, Venues and Organisers. Because it is a legacy db
there are tables which contain old data and I have taken the decision to delete
Exhibitions held 2 years ago or more. Now I want to tidy up the organisers
table so that all organisers who haven't organised one of the remaining current
exhibitions are flagged on the organising company table (tblCompany) so that
the data owner can decide whether they are redundant or not. I created a
sub-query which finds all companies still in tblExhibition, which I use in my
update stored procedure, but it doesn't update anything. Can anyone see what I
am doing wrong - SP sql below: UPDATE dbo.tblCompany SET
CoGrade = 'C' WHERE (NOT EXISTS (SELECT DISTINCT
dbo.tblCompany.CompanyID FROM
dbo.tblCompany INNER JOIN
dbo.tblExhibition ON dbo.tblCompany.CompanyID = dbo.tblExhibition.OrgCoID))
Thanks in advance for any suggestions.