DECLARE @ID int, @TITLE varchar(50), @Count int, @ProductID int, @ProductName varchar(50), @ProductTemplateId int

SET @ProductID = 2
SET @ProductName = 'Address'

DECLARE Colour_Cursor CURSOR FOR
	SELECT ID, Colour 
	FROM PDC_TemplateColour
OPEN Colour_Cursor
FETCH NEXT FROM Colour_Cursor
	INTO @ID, @Title
	WHILE @@FETCH_STATUS = 0
	BEGIN
		SELECT @Count = count(*) FROM PDC_ProductTemplate
		WHERE FK_PDC_TemplateColour = @ID
		AND FK_PDC_Product = @ProductID
	IF @Count < 1
	BEGIN
		INSERT INTO PDC_ProductTemplate
                (Title, FileName, FK_PDC_Product, FK_PDC_TemplateColour)
		VALUES        (@ProductName + @Title, @ProductName + @Title +'.bmp', @ProductID, @ID)
		SET @ProductTemplateId = @@IDENTITY
		PRINT N'INSERTED ' + @ProductName + @Title
		IF @ID IN (4,5,8,12,11,10) 
		BEGIN
			INSERT INTO PDC_ColourSchemeTemplate
				(FK_PDC_ProductTemplate, FK_PDC_ColourScheme)
			VALUES        (@ProductTemplateId,2)
		END
		IF @ID IN (2,3,4,6,12,11) 
		BEGIN
			INSERT INTO PDC_ColourSchemeTemplate
				(FK_PDC_ProductTemplate, FK_PDC_ColourScheme)
			VALUES        (@ProductTemplateId,1)
		END	
	END
	ELSE
	BEGIN
		PRINT N'FOUND ' + @ProductName + @Title
	END
	FETCH NEXT FROM Colour_Cursor
	INTO @ID, @Title
END
CLOSE Colour_Cursor
DEALLOCATE Colour_Cursor