Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Results Sets from Stored Procedures
Message
 
 
À
15/05/2007 17:34:57
Moacyr Zalcman
Independent Consultant
São Paulo, Brésil
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
01225649
Message ID:
01225827
Vues:
22
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform