CREATE PROCEDURE [dbo].[p_createLicenceHcp] 
	-- Add the parameters for the stored procedure here
	@parmDateToCompareFrom	datetime					,
	@parmDateToCompareTo	datetime					,
	@parmOK					int			output	
AS
BEGIN
	DELETE FROM bo_LicenceHcp
	WHERE LicenceHcpDate = @parmDateToCompareTo;

	INSERT INTO bo_LicenceHcp (LicenceHcpLicNbr, LicenceHcpDate)
	SELECT LicNbr, @parmDateToCompareTo
	FROM bo_Licence;

	/* Uppdatera LicenceHcp-poster med korrekt Hcp */
	DECLARE @varHcp		INT;
	DECLARE	@varLicNbr	CHAR(20);
	DECLARE	LicenceHcp	CURSOR FOR
	SELECT	LicenceHcpLicNbr
	FROM	bo_LicenceHcp

	OPEN	LicenceHcp;

	FETCH	LicenceHcp	INTO	@varLicNbr; -- Read Ahead
	WHILE	@@Fetch_Status = 0
	BEGIN
		-- Start Processing ...
		EXEC dbo.p_getLicenceHcpByDate @varLicNbr, @parmDateToCompareFrom, 
@parmDateToCompareTo, 70, 150, 210, @varHcp OUTPUT, 0.0, 0

		IF (@varHcp IS NOT NULL AND @varHcp>=0)
		BEGIN
			UPDATE bo_LicenceHcp
			SET LicenceHcp = isnull(@varHcp,-1)
			WHERE LicenceHcpLicNbr = @varLicNbr AND LicenceHcpDate = @parmDateToCompareTo
		END
		
		-- End Processing ...

		FETCH	LicenceHcp	INTO	@varLicNbr; -- Read
	END

	CLOSE LicenceHcp;

END