Hi,
How can I make a view that gives it's data from az XML file(it has
URL)?

Thanks alot

"Elham Ghoddousi" <Ghoddousi (AT) gmail (DOT) com> wrote

I don't believe there's any way to do that with a native SQL view, but
apparently there are "XML views", which may be closer to what you're looking
for:

http://msdn.microsoft.com/library/de...tions_0gqb.asp

This link might also be relevant:

http://www.sqlxml.org/faqs.aspx?faq=102

If this doesn't help, you might get a better response in
microsoft.public.sqlserver.xml.

Simon