USE [Lombard]
GO
/****** Object:  StoredProcedure [dbo].[auditclient]    Script Date: 16.02.2019 13:47:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[auditclient] 
	-- Add the parameters for the stored procedure here
@idclient int,
 @dataot NVARCHAR(10), 
 @datado NVARCHAR(10)

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	 
	if @dataot IS NOT NULL(

		SELECT count (*) as kolzalvid from t_pledge where t_pledge.id_client=@idclient AND t_pledge.status_pledge='Выдан     ' AND t_pledge.data>@dataot AND t_pledge.data<@datado 
				union
		SELECT count (*) as kolzalreturn from t_pledge where t_pledge.id_client=@idclient AND t_pledge.status_pledge='Возвращен' AND t_pledge.data>@dataot AND t_pledge.data<@datado 
		union
		SELECT count (*) as kolzalnotreturn from t_pledge where t_pledge.id_client=@idclient AND (t_pledge.status_pledge='Реализация' or t_pledge.status_pledge='Реализован') AND t_pledge.data>@dataot AND t_pledge.data<@datado 
)	else(
		SELECT count (*) as kolzalvid from t_pledge where t_pledge.id_client=@idclient AND t_pledge.status_pledge='Выдан' 
		union
		SELECT count (*) as kolzalreturn from t_pledge where t_pledge.id_client=@idclient AND t_pledge.status_pledge='Возвращен' 
		union
		SELECT count (*) as kolzalnotreturn from t_pledge where t_pledge.id_client=@idclient AND (t_pledge.status_pledge='Реализация' or t_pledge.status_pledge='Реализован') 
 )   

	END