Consuming webservices in a view

Hi
Is there a way in sql server 2005 or sql server 2000 to cosume a webservice
over a view?
The aim is to have a view which other appliactions can working with.
The data from the view should not come from a table, it should come per
realtime from a webservice.
thank's
Michel> Is there a way in sql server 2005 or sql server 2000 to cosume a
> webservice over a view?
In SQL 2005, I think you ought to be able to create a CLR function that you
can include in your view. I haven't personally done this, though.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Michel" <michel_mueller@.bluewin.ch> wrote in message
news:e28g7DFgIHA.4396@.TK2MSFTNGP04.phx.gbl...
> Hi
> Is there a way in sql server 2005 or sql server 2000 to cosume a
> webservice over a view?
> The aim is to have a view which other appliactions can working with.
> The data from the view should not come from a table, it should come per
> realtime from a webservice.
> thank's
> Michel
>