Re: What am I doing wrong here?

[Jayadevan M <maymala.jayadevan@xxxxxxxxx>]

Hi,

On Thu, Dec 26, 2019 at 7:06 PM stan <stanb@xxxxxxxxx> wrote:

_bom_name_key  = ( SELECT
                        project_bom_key
                   FROM inserted )
;

Try rewriting
_bom_name_key  = ( SELECT
                        project_bom_key
                   FROM inserted )

as        SELECT project_bom_key into _bom_name_key
                   FROM inserted ;

Regards,

Jayadevan