A parameter map that nests prompts

Note the following:

  • In the model, there is a parameter map DynPromptLabels with #$PromptLabels{$language}#
  • Part of the prompt information is run from a parameter map instead of being coded directly inside the SQL.
  • The whole macro containing the prompt can be a value in a parameter map.
select 
	ORDER_METHOD.ORDER_METHOD_CODE as ORDER_METHOD_CODE,
	ORDER_METHOD.ORDER_METHOD_#$language#
	as ORDER_METHOD_EN 
from 
	gosales.gosales.dbo.ORDER_METHOD ORDER_METHOD
#prompt($DynPromptLabels{'ex9'},
	'',
	' ',
	'where ORDER_METHOD.ORDER_METHOD_' + $language + '
>'
)#