The query I created has several Select statements bounded by the Union operator. This query uses the For XML Explicit clause. Query looks like the following...
select 1 as tag,
null as parent,
'' as [Enterprise!1],
null as [Properties!2!DataSource!element],
null as [Properties!2!DateTime!element],
---
--- other fields are defined here
---
from Table1 a (nolock)
union
select 2 as tag,
1 as parent,
'',
'WebCT' as DataSource,
getdate() as DateTime,
---
--- other fields are defined here
---
from table1 a (nolock)
union
---
--- other Select statements are defined here
---
For XML explicit
How can I define this query when executing the sp_makewebtask cmd? How should I format/define the template file?
select 1 as tag,
null as parent,
'' as [Enterprise!1],
null as [Properties!2!DataSource!element],
null as [Properties!2!DateTime!element],
---
--- other fields are defined here
---
from Table1 a (nolock)
union
select 2 as tag,
1 as parent,
'',
'WebCT' as DataSource,
getdate() as DateTime,
---
--- other fields are defined here
---
from table1 a (nolock)
union
---
--- other Select statements are defined here
---
For XML explicit
How can I define this query when executing the sp_makewebtask cmd? How should I format/define the template file?