SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE createApplicationTable
 @param nvarchar(4000)
AS
BEGIN
DECLARE @eventName varchar(20)
, @event varchar(20), @applicationNo varchar(20), @date date

CREATE TABLE WnioskiV
	(
	[ID] [int] NOT NULL,
	[Numer wniosku] [varchar](50),
	[Nazwa zdarzenia] [varchar](20),
	Data date
) ON [PRIMARY]

DECLARE eventCursor CURSOR FOR
	select Nazwa_zdarzenia
	from Zdarzenie

	OPEN eventCursor

	FETCH NEXT FROM eventCursor INTO
	@eventName

	set @param = ' '

	WHILE @@FETCH_STATUS = 0
	BEGIN
		PRINT @param
		SET @param = @param + '(' +  @eventName  + ',' + '[' + @eventName +  ']' + '), '


		--SET @param =  @param + '(@eventName, [@eventName])'

		FETCH NEXT FROM eventCursor INTO
		@eventName
	END
	CLOSE eventCursor
	DEALLOCATE eventCursor

DECLARE tableCursor CURSOR FOR
	SELECT [Numer wniosku], [Nazwa zdarzenia], Data
	FROM Stage
	CROSS APPLY (
	VALUES @param ) x([Nazwa zdarzenia], Data)

	OPEN tableCursor

	FETCH NEXT FROM tableCursor INTO
	@applicationNo, @event, @date

	WHILE @@FETCH_STATUS = 0
	BEGIN

		INSERT INTO WnioskiV ([Numer wniosku], [Nazwa zdarzenia], Data)
		VALUES (@applicationNo, @event, @date)

		FETCH NEXT FROM tableCursor INTO
		@applicationNo, @event, @date
	END
	CLOSE tableCursor
	DEALLOCATE tableCursor

execute createApplicationTable @param

END
GO