<div>
it is not clear what the parameter has to do with the FOR XML part, can you specify, please
</div>


it is not clear what the parameter has to do with the FOR XML part, can you specify, please

<div>
i have a select statement that i am passing to sql for an asp page. it is currently bringing in the query results as the data source for the page and then the user filters it. then we have to format it by creating multiple &quot;tables&quot; on the page. <br />
<br />
i want to change the sql to reference the stored procedure that has a parameter of Job Number. But I would also like to use the For XML in the SP, but was not sure if it could be used with a parameter. <br />
<br />
adria
</div>


i have a select statement that i am passing to sql for an asp page. it is currently bringing in the query results as the data source for the page and then the user filters it. then we have to format it by creating multiple "tables" on the page.

i want to change the sql to reference the stored procedure that has a parameter of Job Number. But I would also like to use the For XML in the SP, but was not sure if it could be used with a parameter.

adria

<div>
<div class="content wysiwyg-content">
SQL 2k5<br />
<br />
Is it possible to use For XML on a stored procedure that has a parameter?<br />
<br />
adria
</div>
</div>


SQL 2k5

Is it possible to use For XML on a stored procedure that has a parameter?

adria

For XML/SP

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.