Post reply

View Definitions

  • December 15, 2008 at 12:38 pm

    #72314

    I have some fairly complex views and want to display the definition of the view columns in some way that's dynamic. So if it looks like this:

    Create view vTest

    As

    Select MyTable.ColA as DisplayColA,

    MyTable.ColB + MyTable.ColC as DisplayColB

    FromMyTable

    I want to be able to have a report where I can say

    ViewColumnDefinition

    vTestDisplayColBMyTable.ColB + MyTable.ColC

  • December 15, 2008 at 12:46 pm

    #912722

    Please do not double post. First things first, what version of SQL server are you using?

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • December 15, 2008 at 12:55 pm

    #912730

    I'm working in both SQL 2000 and 2005, so although I did double post, the situation applies to each system.

  • December 15, 2008 at 1:01 pm

    #912737

    We'll call this one the duplicate then.

    Please direct all replies to:

    http://www.sqlservercentral.com/Forums/Topic619897-338-1.aspx

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply