Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Consuming the rows of a called SP inside another SP
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01171249
Message ID:
01171488
Views:
6
>You didn't have to go to another forum. See Message #1171277 in this thread.
>
>>Here another approach, suggested by a member of another forum (I even didn't thought about this :o):
>>
>>SELECT  count(*)
>>FROM    OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off exec YourDB.dbo.SP_1)
>>AS tbl
>>
ROFL
I was so asleep yesterday, that I miss that one.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform