Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SP desde ASP

2 views
Skip to first unread message

Mauricio Henao

unread,
Jun 11, 2016, 6:45:02 PM6/11/16
to
Hola a todos, por favor, necesito ayuda.

En una BD de SEL server hay un Store Procedure que hace:

ALTER PROCEDURE [dbo].[IndexData]
@user varchar(30),
@TotalClients int Output,
@TotalDocuments int Output,
@TotalClosed int Output,
@TotalOpen int Output,
@TotalAreas int Output

AS
BEGIN

SET NOCOUNT ON;

select TotalClients= count(id) from tblclients where year(dtmdate)=year(getdate())

select TotalDocuments=count(id) from tbldocument where year(dtmcrtdate)=year(getdate())

select TotalClosed=count(id) from tbldocument where struser=@user and year(dtmcrtdate)=year(getdate()) and intclosed=0

select TotalOpen=count(id) from tbldocument where struser=@user and year(dtmcloseddate)=year(getdate()) and intclosed=1

select TotalAreas=count(id) from Tblpracticeareas where intactivo=1

return @TotalClients
return @TotalDocuments
return @TotalClosed
return @TotalOpen
return @TotalAreas
END


Como puedo recuperar en ASP clasico los valores que retorna?

Gracias!
0 new messages