Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sp_makewebtask and a For XML Explicit query

Status
Not open for further replies.

rq

Programmer
Jun 13, 2002
56
0
0
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top