FowlerConsulting
Vendor
I need to update the contents table for every child entity of parent entity, and the parent entity itself.
I am an Oracle DBA, and I have to do somthing like this in MS SQL:
Here are the tables:
Thanks
Steven Fowler
info@fowlerconsulting.com
I am an Oracle DBA, and I have to do somthing like this in MS SQL:
Code:
UPDATE Contents
Font = 'Arial'
WHERE Contents.Entity_ID IN
(SELECT Contents.Entity_ID
FORM Contents, Entities
WHERE Contents.Entity_ID = Entities.Entity_ID
AND Entities.Parent_ID = 94)
Here are the tables:
Code:
[Entities]
Entity_ID
Parent_ID
Creator_ID
Entity_Name
Entity_Name_Abr
Entity_Type
Entity_Status
Public_Entity
Time_Stamp
[Contents]
Entity_ID
Font
BGColor
Time_Stamp
Thanks
Steven Fowler
info@fowlerconsulting.com