Can a stored procedures result set be returned

Pls give some samplesOriginally posted by bennydubai
Pls give some samples

create procedure theExample as
select * from sysobjects|||Got it!!! Thanks............getting the column count in tables.

select sysobjects.name,count(*) from sysobjects
join syscolumns on syscolumns.id=sysobjects.id
where sysobjects.xtype='u'
group by sysobjects.name|||OR BETTER THIS WAY

SELECT
count(*)
FROM INFORMATION_SCHEMA.COLUMNS
where table_name='staff'

callinga web service?

Hi All
can i in call a web service from SP/function
(without using COM SP's) in any way ?
and represent the returned xml as a resultset ?
TIA
Danny
I don't think this is possible in SQL Server 2000 without using the sp_OA
procs or writing an extended stored proc.
In Yukon, you can write a CLR UDF.
Best regards
Michael
"Danny" <danny.ravid@.ness.com> wrote in message
news:eb2d01c43cee$7257dba0$a301280a@.phx.gbl...
> Hi All
> can i in call a web service from SP/function
> (without using COM SP's) in any way ?
> and represent the returned xml as a resultset ?
> TIA
> Danny

Calling XML web service from a reporting services report (RDL)

Hi,

I wanted to display data returned by xml webservice in a sql reporting service report(RDL).

How I can implement the same, Please let me know the steps.

Thanks,

Anees

Check this: http://msdn.microsoft.com/library/en-us/dnsql90/html/RepServXMLDS.asp

Calling XML web service from a reporting services report (RDL)

Hi,

I wanted to display data returned by xml webservice in a sql reporting service report(RDL).

How I can implement the same, Please let me know the steps.

Thanks,

Anees

Check this: http://msdn.microsoft.com/library/en-us/dnsql90/html/RepServXMLDS.asp