I just use a simple example to illustrate what I want to achieve. In reality I have a dynamic sql to openquery a MDX query and the parameterized MDX query sometimes return empty result set that will throw errors and break the code, I thought to use a Try catch block to catch the error but am not clear about the flow the block but now everything is solved. Thank you for the input!