I have the follwing proc but it isn't doing what I want it to:) It updates
entries for a link directory once they have been approved. I want it to
update the totalLinks column on the link category and any parent categories.
The Link Table contains a column ParentCatID which is its parents catID. Any
help to get this finished would be greatly appreciated
[LinkID] [bigint] IDENTITY (1, 1) NOT NULL ,
[TypeID] [int] NULL ,
[LinkName] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL ,
[URL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Address1] [nvarchar] ...