Sample Header Ad - 728x90

How to write SQL Stored Procedure to ouput a fixed Length/width File

0 votes
1 answer
1658 views
I am using SQL server 2017, I want to write SQL stored procedure to generate a fixed length/width file without using SSIS or wizard TABLE: |EmpID|EmployeeName|Department|Birthdate|Hiredate| |-----|------------|----------|---------|--------| |001|John Doe|Marketing|1986-08-31|2006-04-01| |002|Jane Doe|Sales|1975-01-17|2000-06-27| |003|Mark Vaughn|Production|1993-05-09|2017-03-06| |004|xxxxx xxxxx|xxxxxxxxx|yyyy-mm-dd|yyyy-mm-dd| |004|xxxxx xxxxx|xxxxxxxxx|yyyy-mm-dd|yyyy-mm-dd| TO
EmpID       EmployeeName        Department     Birthdate     Hiredate
001         John Doe            Marketing      1986-08-31    2006-04-01   
002         Jane Doe            Sales          1975-01-17    2000-06-27
003         Mark Vaughn         Production     1993-05-09    2017-03-06
004         xxxxx  xxxxx        xxxxxxxxx      yyyy-mm-dd    yyyy-mm-dd
004         xxxxx  xxxxx        xxxxxxxxx      yyyy-mm-dd    yyyy-mm-dd
Where 1.EmpID (10) 2.EmployeeName (40) 3.Department(20) 4.Birthdate(8) 5.Hiredate(8)
Asked by Y.agr (13 rep)
Dec 30, 2022, 01:29 PM
Last activity: Dec 30, 2022, 08:10 PM