iasset.com interview question

SQL common table expressions, transactionscope etc