USE [dboArvato]
GO
/****** Object:  StoredProcedure [dbo].[selectValidateJefeCamp]    Script Date: 05/04/2012 15:48:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[selectValidateJefeCamp]
 @USER VARCHAR(50),
 @CAMPAIGN INT
AS
begin

declare @valRet varchar (1);
set @valRet='a';
if exists (SELECT ID_USUARIO FROM TCMP_CAMPANIA_RESPONSABLE WHERE (ID_USUARIO = @USER AND ID_CAMPANIA = @CAMPAIGN))
 begin
  set @valRet= 'b';
  if exists( SELECT top 1 TUSU_USUARIO.ID_USUARIO, TUSU_USUARIO.NOMBRE_EMP, TCMP_CAMPANIA.ID_CAMPANIA
   FROM         TMET_USUARIO_TAREA INNER JOIN
          TMET_TAREA ON TMET_USUARIO_TAREA.ID_TAREA = TMET_TAREA.ID_TAREA INNER JOIN
          TCMP_CAMPANIA ON TMET_TAREA.ID_CAMPANIA = TCMP_CAMPANIA.ID_CAMPANIA INNER JOIN
          TUSU_USUARIO ON TMET_USUARIO_TAREA.ID_USUARIO = TUSU_USUARIO.ID_USUARIO
   WHERE     (TCMP_CAMPANIA.ID_CAMPANIA = @CAMPAIGN))
    set @valRet= 'c'
 end
else
 begin
  set @valRet= 'a'
 end
select @valRet as Valor;
END