What are the challenges you face when working across database platforms? Take the survey
Options

Field erroneously showing up twice in the suggestion list

dcolbertdcolbert Posts: 15
edited March 11, 2011 3:53PM in SQL Prompt Previous Versions
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

Comments

  • Options
    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
    Project Manager, Red Gate
  • Options
    For some reason it's not doing it anymore.

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

    Thanks Paul!
Sign In or Register to comment.