Export to text files based on a value and if employee has multiple reasons show all reasons to that particular employee.

I have a SQL Functions that export from SQL table to text files based on a value that works perfectly. BIG THANKS to MARK WILLIS for his expertise. I really appreciate his intelligence and help.

My apology I was not clear when I first asked this question.

My problem is when an employee has multiple reasons, I only want to show all reasons only to that particular employee. I don't want it to go to the next page if reasons belong to the same employee. Only a different employee goes to the next page in a text file.

This is the SQL Functions:

ALTER FUNCTION [dbo].[udf_export_employee](@filename varchar(50))
RETURNS @textfile table 
	(
	linectr int identity, 
	rundate datetime, 
	[Filename] varchar(50),
	exportrecord varchar (500)
	)
AS
BEGIN
	
	DECLARE @rundate datetime = getdate()
	DECLARE @pagecounter int = 0
	DECLARE @Employee_UniqueID varchar(50)
	DECLARE @Employee_Filename varchar(50)
	DECLARE filename_cursor CURSOR FOR SELECT UniqueID,[Filename] from Employee where [Filename] = @filename

	OPEN filename_cursor
	FETCH NEXT FROM filename_cursor INTO @Employee_UniqueID,@Employee_Filename
	WHILE @@FETCH_STATUS = 0
	BEGIN

		SET @pagecounter = @pagecounter + 1

		IF @pagecounter = 1
		BEGIN
			INSERT @textfile SELECT @rundate,@filename,'------------------------ '+ConstantVariable+' ------------------------' 
                              FROM ConstantVariable1 where UniqueID = @pagecounter
   			INSERT @textfile SELECT @rundate,@filename,'                                                       '
   			INSERT @textfile SELECT @rundate,@filename,'                                                       '
   			INSERT @textfile SELECT @rundate,@filename,'                                                       '
		END
		ELSE
		BEGIN
			INSERT @textfile SELECT @rundate,@filename,'------------------------ Page '+convert(varchar(3),@pagecounter)+' ------------------------' 
   			INSERT @textfile SELECT @rundate,@filename,'                                                       '
   			INSERT @textfile SELECT @rundate,@filename,'                                                       '
   			INSERT @textfile SELECT @rundate,@filename,'                                                       '
		END

		INSERT @textfile SELECT @rundate,@filename,'EMPLOYEE NAME: ' + EmployeeName from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
		INSERT @textfile SELECT @rundate,@filename,'EMPLOYEE ADDRESS: ' + EmployeeAddress from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
		INSERT @textfile SELECT @rundate,@filename,'EMPLOYEE CITY: ' + EmployeeCity from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
		INSERT @textfile SELECT @rundate,@filename,'EMPLOYEE ZIP: ' + EmployeeZip from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
    	INSERT @textfile SELECT @rundate,@filename,'                                                       '
		INSERT @textfile SELECT @rundate,@filename,'EMPLOYEE EMPLOYMENT DATE: ' + EmploymentDate from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
    	INSERT @textfile SELECT @rundate,@filename,'                                                       '
		INSERT @textfile SELECT @rundate,@filename,'EMPLOYER NAME: ' + EmployerName from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
		INSERT @textfile SELECT @rundate,@filename,'EMPLOYER ADDRESS: ' + EmployerAddress from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
		INSERT @textfile SELECT @rundate,@filename,'EMPLOYER CITY: ' + EmployerCity from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
		INSERT @textfile SELECT @rundate,@filename,'EMPLOYER ZIP: ' + EmployerZip from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
    	INSERT @textfile SELECT @rundate,@filename,'                                                       '
		INSERT @textfile SELECT @rundate,@filename,'REASONS ' + 'DESCRIPTIONS ' + 'AMOUNT ' from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename
		--THIS IS WHERE THE REASONS, DESCRIPTION, AND AMOUNT GOES PER EMPLOYEE ---INSERT @textfile SELECT @rundate,@filename,Reasons from Employee where UniqueID = @Employee_UniqueID and [Filename] = @Employee_Filename

		FETCH NEXT FROM filename_cursor INTO @Employee_UniqueID,@Employee_Filename

	END

	CLOSE filename_cursor
	DEALLOCATE filename_cursor

	IF @pagecounter = 0
    	INSERT @textfile SELECT @rundate,@filename,'No Employee Details Exist For '+@filename
	   

	RETURN
END

Select allOpen in new window

Is this possible? I tried to play around with the SQL query but I cannot get it to work. See attached.

Please help.

Thank you again for all your help.
SQLTables--3-.xlsx
File1_12272017.txt
File2_12272017.txt
File3_12272017.txt