Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

Keep getting "Ambiguous name in query expresion" error

Hello,
I keep getting the error "Ambiguous name in query expresion. 'Swap([Diamond]'. When I try to execute the following query.  It's telling me that there is a mispelling or something of that nature.  What am I missing?

UPDATE STAGE_INST_HDR SET STAGE_INST_HDR.ALIAS = Swap([Diamond Id])
WHERE ((Not (STAGE_INST_HDR.[Diamond Id]) Is Null));
0
chtullu135
Asked:
chtullu135
  • 4
  • 2
1 Solution
 
sdstuberCommented:
DO you have multiple objects named Diamond Id?


if so, dereference it from the table as you did in the where clause



UPDATE STAGE_INST_HDR SET STAGE_INST_HDR.ALIAS = Swap(STAGE_INST_HDR.[Diamond Id])
WHERE ((Not (STAGE_INST_HDR.[Diamond Id]) Is Null));
0
 
chtullu135Author Commented:
I found the solution.  There were two functions with the same name.  I removed one and it works
0
 
chtullu135Author Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for chtullu135's comment http:/Q_27420757.html#37047839

for the following reason:

I found the problem on my own.  I discovered that there were two functions with the identical name.  When I removed one of them, the query works
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
sdstuberCommented:
>>>> two functions with the same name

isn't that what was originally suggested?
0
 
South ModModeratorCommented:
sdstuber suggested exactly that in their first comment: "Do you have multiple objects named Diamond ID". As such, I've accepted that comment as the solution.

SouthMod
Community Support Moderator
0
 
chtullu135Author Commented:
I had multiple objects named Swap not diamond id but I get your point.
0
 
chtullu135Author Commented:
I've accepted sdtubers suggestion
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now