|
Posted by David Portas on 09/29/05 01:01
Please do not multi-post!
I answered in microsoft.public.sqlserver.programming
--
David Portas
SQL Server MVP
--
<alacrite@gmail.com> wrote in message
news:1127934231.076210.62130@g47g2000cwa.googlegroups.com...
> I will apologize in advanced for spamming the group with newbie
> questions. I do not have a reference in front of me and several google
> attempts have come up on sucessful for the kind of information that I
> am looking for. That being said here is my question/problem:
>
> In a MSSQL database I want to create a trigger. I have 'product'
> table where products can be linked together via a 'link' table to other
> products. In this particular situation there can be a kind of master
> product that other products are then cloned(i.e. they have the same
> record values other than primary key) from (yes lot of data
> redundancy!). If a clone is made from the master there is a link
> between the two id's of the 'product' table made in the 'link' table.
> Now the trigger must coordinate the the master products prices with
> the linked products.
>
> Here is a query that does what I want I just need it in trigger form.
>
> update product
> set price = (select price from product where prod_id = xxxyz)
> where prod_id in (select related_id
> from link
> where id = xxxyz)
>
> where xxxyz is the prod_id of the master product whose price is being
> updated.
>
> (I know this is not the ideal database set up but it is what I have to
> work with )
>
> - thanks!
> Jake
>
Navigation:
[Reply to this message]
|