set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[AddPrintLayout] 
	(
	@FKID int,
	@LayoutName nvarchar(50),
	@Xmldata varbinary(Max),
	@PrimaryLayout bit,
	@ID int output	)
AS

	Begin
		if @id >0 
			update  PrintLayouts set XMLdata=@XmlData where id=@id
		else
			begin
			INSERT INTO PrintLayouts
			                      (LayoutName, XMLdata,  PrimaryLayout, FKID)
			VALUES     (@LayoutName,@XmlData,@PrimaryLayout,@FKID)
			SET @ID=(select IDENT_CURRENT('PrintLayouts'))
			end 
	END