For XML/SP

SQL 2k5

Is it possible to use For XML on a stored procedure that has a parameter?

adria
LVL 13
adraughnAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, you can use parameters in a stored procedure for a query that specifies FOR XML.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
it is not clear what the parameter has to do with the FOR XML part, can you specify, please
0
 
adraughnAuthor Commented:
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
0
 
adraughnAuthor Commented:
gracias
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.