Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    outside the rim

    Unanswered: Stop renaming my tables!!!

    Is there a way to disable to automatic renaming of source tables by the View editor? (SLQ Server 2008 R2)

    I have a view that is using several sub-queries (including a "rank/partition") and even though each sub-query is contained in ( ) and given an alias, the view designer automatically adds the _1, _2 to all of the tables it thinks are duplicates, which then invalidates the and explicit field calls in CASE WHEN statements ...

    have fun!

    Todd S.
    click to email

    Independent Development Consultant
    Biz db & reports - SQL, Access, Crystal, Seradex and more
    Small, custom, unique programs - Office, VBA, .NET

    Favorite message from Windows:
    There was an error displaying the previous error message

    Sadly, there was no error number to look up ...

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    You should really move away from using the Designer view, and just deal directly with the SQL code.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts