tobin46
asked on
Query Results to Text File
Is it possible to run a query and have results export to text file in pre-defined column widths with leading zeros if required?
I'm hoping I may be able to build a text file that I can import into a system. It's 5 fields, all numeric, the results would need to look like this....
00000100002000000000300000 0000400000 0000500000 0000
First field is 10,000
2nd is 2,000,000,000.....etc
I'm hoping I may be able to build a text file that I can import into a system. It's 5 fields, all numeric, the results would need to look like this....
00000100002000000000300000
First field is 10,000
2nd is 2,000,000,000.....etc
Check the SQL - BCP QUERY OUT for your requirements.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.