Dynamic parameters

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  March 24, 2005 at 9:09 am

  #163991

  I am looking for a way to create dynamic parameters.  The user will choose something from the first parameter list.  The second parameter list will dynamically be modified based on what was chosen in the first parameter.  A pointer to a good book that contains the topic will also be appreciated.

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  March 24, 2005 at 9:31 am

  #548796

  I just found what I was looking for.  It is called "Cascading Parameters". 

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor