How can we help you today? How can we help you today?

Field erroneously showing up twice in the suggestion list

I have the following query:
SELECT [AvailableForPurchase].[KC_ID],
[title_id],
[DayOfYear],
[AFP]
FROM [Aggregation].[dbo].[AvailableForPurchase] WITH (NOLOCK)

When I use CTRL-[Space] to expose the suggestion list, each column shows up twice in the suggestion list, despite only existing once in [AvailableForPurchase].

Why is this happening?

Thanks in advance!

Dan
dcolbert
0

Comments

2 comments

Sort by
  • Paul Stephenson
    Hi Dan,

    I've tried reproducing this by creating the AvailableForPurchase table, but I only see each column once in the suggestions list, as expected.

    I tried creating the table in both the current database, and also (since you referred to it as Aggregation.dbo.AvailableForPurchase) in a different database, but with the same results.

    Would it be possible for you to post full reproduction steps, starting with an empty database?

    Regards,
    Paul
    Paul Stephenson
    0
  • dcolbert
    For some reason it's not doing it anymore.

    If I see it again, I'll post what I know.

    Thanks Paul!
    dcolbert
    0

Add comment

Please sign in to leave a comment.