Flowing Fount of Yak Knowledge
quote:Originally posted by gavilivI am trying to update columns in a table based on join condition and included in create statement using case statement:Following is part of create statement:[SAV Sub-Segment] AS (case when ([Validated End Customer Name]=[dbo].[SLED_VAL-GM-MAPPING].[SAV Name]) THEN [dbo].[SLED_VAL-GM-MAPPING].[SAV Sub Segment ] else NULL end),and get the following error"The multi-part identifier "dbo.SLED_VAL-GM-MAPPING.SAV Name" could not be bound."
Premature Yak Congratulator