Mauricio Henao
unread,Jun 11, 2016, 6:45:02 PM6/11/16You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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!