SELECT TOP  1000 
		journal_service.UID,
		journal_service.UIDOwner,
		journal_service.DTInsert,
		journal_service.DTUpdate,
		journal_service.UIDService,
		journal_service.UIDBill,
		list_service.Caption AS CaptionService,
		list_unit.Caption AS CaptionUnit,
		journal_service.Quantity,
		journal_service.Lag,
		journal_service.Discount,
		journal_service.Taxrate,
		journal_service.Caption,
		CASE WHEN (sum_charge.UIDPayer IS NOT NULL) THEN sum_charge.UIDPayer
			ELSE sum_pay.UIDPayer
		END AS UIDPayer,
		CASE WHEN (sum_charge.UIDRecipient IS NOT NULL) THEN sum_charge.UIDRecipient
			ELSE sum_pay.UIDRecipient
		END AS UIDRecipient,
		journal_service.UIDManPay,
		journal_service.UIDManCharge,
		journal_service.UIDManClient,
		CASE WHEN (sum_pay.SumPay IS NULL) THEN NULL
							    ELSE journal_service.DTPay
		END AS DTPay,
		CASE WHEN (sum_charge.SumCharge IS NULL) THEN NULL
							    ELSE journal_service.DTCharge
		END AS DTCharge,
		sum_pay.SumPay,
		sum_charge.SumCharge,
		CASE WHEN (sum_charge.SumCharge IS NULL) THEN  1 
								 ELSE  2 
		END AS Charge,
		CASE WHEN (sum_pay.SumPay IS NULL) THEN  1 
							    ELSE  2 
		END AS Pay
	FROM 
		journal_service
		LEFT OUTER JOIN list_service ON  journal_service.UIDService = list_service.UID
		LEFT OUTER JOIN list_unit ON list_service.UIDUnit = list_unit.UID
		LEFT OUTER JOIN (SELECT DISTINCT UIDService, max(DTActual) AS MaxDate
			FROM journal_service_taxrate
			GROUP BY UIDService) AS max_date ON list_service.UID=max_date.UIDService
		LEFT OUTER JOIN journal_service_taxrate ON ((max_date.UIDService=journal_service_taxrate.UIDService) and (max_date.MaxDate=journal_service_taxrate.DTActual))
		LEFT OUTER JOIN (SELECT bind_amount_service.UIDJournalService, journal_amount.UIDPayer, journal_amount.UIDRecipient, sum(journal_amount.Amount) AS SumCharge
			FROM	journal_amount
				LEFT OUTER JOIN bind_amount_service ON journal_amount.UID=bind_amount_service.UIDAmount
				LEFT OUTER JOIN journal_service ON bind_amount_service.UIDJournalService=journal_service.UID
			WHERE journal_amount.UIDRecipient=journal_service.UIDPayer
			GROUP BY bind_amount_service.UIDJournalService, journal_amount.UIDPayer, journal_amount.UIDRecipient) AS sum_charge ON journal_service.UID=sum_charge.UIDJournalService
		LEFT OUTER JOIN (SELECT bind_amount_service.UIDJournalService,  journal_amount.UIDPayer, journal_amount.UIDRecipient, sum(journal_amount.Amount) AS SumPay
			FROM	journal_amount
				LEFT OUTER JOIN bind_amount_service ON journal_amount.UID=bind_amount_service.UIDAmount
				LEFT OUTER JOIN journal_service ON bind_amount_service.UIDJournalService=journal_service.UID
			WHERE journal_amount.UIDPayer=journal_service.UIDPayer
			GROUP BY bind_amount_service.UIDJournalService, journal_amount.UIDPayer, journal_amount.UIDRecipient) AS sum_pay ON journal_service.UID=sum_pay.UIDJournalService
	WHERE 
		((@UIDService=journal_service.UIDService) or (@UIDService IS NULL)) and
		((@UIDBill=journal_service.UIDBill) or (@UIDBill IS NULL)) and
		((@UIDManPay=journal_service.UIDManPay) or (@UIDManPay IS NULL)) and
		((@UIDManCharge=journal_service.UIDManCharge) or (@UIDManCharge IS NULL)) and
		((@UIDManClient=journal_service.UIDManClient) or (@UIDManClient IS NULL)) and
		(((sum_pay.SumPay IS NOT NULL) and (@Pay= 2 )) or
		((sum_pay.SumPay IS NULL) and (@Pay= 1 )) or
		(@Pay= 0 )) and
		(((sum_charge.SumCharge IS NOT NULL) and (@Pay= 2 )) or
		((sum_charge.SumCharge IS NULL) and (@Pay= 1 )) or
		(@Pay= 0 )) and
		((@UIDPayer=journal_service.UIDPayer) or (@UIDPayer IS NULL))and
		((sum_pay.UIDPayer=@UIDPayer) or (sum_charge.UIDPayer=@UIDPayer) or (@UIDPayer IS NULL)) and
		((sum_pay.UIDRecipient=@UIDRecipient) or (sum_charge.UIDRecipient=@UIDRecipient) or (@UIDRecipient IS NULL)) and
		(((sum_pay.SumPay IS NOT NULL) and (@DTPayBegin<=DTPay)) or (@DTPayBegin IS NULL)) and
		(((sum_pay.SumPay IS NOT NULL) and (@DTPayEnd>=DTPay)) or (@DTPayEnd IS NULL))  --and
 
 --		(((sum_charge.SumCharge IS NOT NULL) and (@DTChargeBegin<=DTCharge)) or (@DTChargeBegin IS NULL)) and
 
--		(((sum_charge.SumCharge IS NOT NULL) and (@DTChargeEnd>=DTCharge)) or (@DTChargeEnd IS NULL))

CREATE PROCEDURE JournalServiceSelect
	@UIDService int = NULL,
	@UIDBill int = NULL,
	@UIDPayer int = NULL,
	@UIDRecipient int = NULL,
	@Pay int = NULL,
	@Charge int = NULL,
	@DTPayBegin datetime = NULL,
	@DTPayEnd datetime = NULL,
	@DTChargeBegin datetime = NULL,
	@DTChargeEnd datetime = NULL,
	@UIDManPay int = NULL,
	@UIDManCharge int = NULL,
	@UIDManClient int = NULL