Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011

    Unanswered: Columns in view not selectable


    We have a nested view which compiled successfully first time but we were unable to select a certain set of columns from the view. The un-selectable columns were at the very end of select list for the view definition. We got around this problem by re-compiling this already complied view- Any idea why this could be happening?


  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    The problem is located between lines 15 and 20. I have corrected those lines and as you can see it is now working perfect. Even right after the very first compilation.

    Perhaps you had only a part of the view selected when you clocked Execute/F5, that way only part of the view got "compiled".
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Tags for this Thread

Posting Permissions

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