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
Last activity: Dec 30, 2022, 08:10 PM