Is it possible to create generate xsi:schemaLocation="http://
http://.../name.xsd" while using the for XML Path syntax? I am able to define
everthing else except that (see example) below. Any help would be greatly
appreciated...Thanks

Example:
<Example xmlns:xsi="http://..." xsi:schemaLocation="http://...
http://.../name.xsd" xmlns="http://...">

SQL Syntax (so far):
WITH XMLNAMESPACES (default 'http://...')
select
        x.id_example as 'ExampleID'
from table x
for xml path ('Transaction'),
        root('Example')   -- Generate Single Top level Element
    ,ELEMENTS XSINIL -- Adds Elements for Null Values (Also adds
"xmlns:xsi=...")