Dear Sir,
I need to get output in text file from mssql
This is the format which I have raised from website of ICEGATE EDI format
ICEGATE Header:
HREC^]ZZ^]^]ZZ^]^]^]^] ^]^]^]^]
Example:
HREC^]ZZ^]ABCD^]ZZ^]XYZ^]ICES1_5^]P^]^]COCHE01^]123456^]20071015^]1015
Pont 1 : When I open the Output in Notepad I get in this manner without any spaces in between
--------------------------------------------------Point 1------------------------------
HRECZZAAACF2188HZZINNSA1ICES1_5TSACHI011201512080959
Point 2 : When I open the Output in Word pad I get in this manner with spaces in between
--------------------------------------------------Point 2------------------------------
HREC ZZ AAACF2188H ZZ INNSA1 ICES1_5 T SACHI01 1 20151208 0959
Point 3 : When I open the Output in Notepad++ I get in this manner with GS where space shown ie Group Separater
How can I handle this via syntax in MSSQL