Unable to find specified provider.
Error occurred while establishing connection to Oracle server. You might have 32-bit connectivity components installed on the machine, in order for SSMA to make use of those connectivity libraries, you need to run the 32-bit version of SSMA application whose shortcut can be found under the Programs menu. SSMA-for-Oracle.png
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …