Posted on: 2/13/2015 7:02:27 PM | Views : 555

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 ...