View Definition display

• andreq1-726318

  SSC Veteran

  Points: 246

  More actions

  December 15, 2008 at 12:39 pm

  #128367

  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

• Garadin

  One Orange Chip

  Points: 29613

  More actions

  December 15, 2008 at 1:02 pm

  #912739

  andreq1 (12/15/2008)

  ---

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

  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]