General information
Forum:
Microsoft SQL Server
update parent
set childcount =
(select COUNT(item_code)
from child
where child.pcode = parent.pcode)
from parent
If you do this in an insert trigger to the child you can do something like...
update parent
set childcount =
(select COUNT(item_code)
from child
where child.pcode = parent.pcode)
from parent
join inserted on parent.pcode=inserted.pcode
**********
BOb
>Hello,
>
>I'm trying to figure out the syntax for updating a count column based on the child table count.
>Parent table has the columns columns pcode, childcount
>Child table has the columns pcode, childname
>
>I'm thinking I want to do something like the following, though I'm stuck
>figuring out how to finish the sql
>
>update parent
>set childcount =
> (select COUNT(item_code)
> from child
> where child.pcode = parent.pcode)
>
>How do I tell the subquery what the parent.pcode is?
>
>Any suggestions would be greatly appreciated.
>
>Thanks,
>-Isaac
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only