Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Results Sets from Stored Procedures
Message
 
 
To
15/05/2007 17:34:57
Moacyr Zalcman
Independent Consultant
São Paulo, Brazil
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01225649
Message ID:
01225827
Views:
19
This message has been marked as a message which has helped to the initial question of the thread.
...
               --select * from #DUtil where dia=@dtinicio
               --if @@rowcount=0
               if NOT EXISTS(select * from #DUtil where dia=@dtinicio)
...
>
>I give just an example, but it is probably a bad one.
>I will show you my real need:
>
>I have this sproc
>
<snip>
>This sproc receive two parameters, an inicial date and a number of days and I get the date after that inicial date plus that number of days excluding weekend and holidays( the holidays I have in a table called 'feriado') as an output parameter.
>Everything works fine, but when I run these sproc I get the output parameter and also an cursor that was created with the [select * from #DUtil where dia=@dtinicio]. I don't need this cursor. Is there any way to avoid the delivery of this cursor to the client?
>
>I hope you can now understand my need and thanks for your help.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform