hi,
I have a SQL database with a Images Table and Models table as below
Images
ImageId / p /k
ModelId - guid
Model
ModelId- GUID - p/ k
FirstName - ncar char
LastName - nvar -char
HasPictures- boolean
I want to run a SQL Update statement from management studio that checks the
Image table to see if there are Pictures that belong to each ModelId
IF NOT then i want to Update HasPictures = false in the Models Table?
it is currently true by default..
thank you for examples how to run this
Go to the complete details ...