Why not the same

Last Post 28 Jul 2010 05:25 AM by russellb. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
Topic is locked
Author Messages
Zoran, Jagodina
New Member
New Member

--
27 Jul 2010 01:24 AM
I have source file A.TXT ---------------------------------------------------- 100140720102223470000103 200XXXX 000015000000010007000 200YY 000019000000010001600 200Z 000007000000010011200 3000000004100000 I got target ------------------------------- 100140720102223470000103 200XXXX 000015000000010007000 200YY 000019000000010001600 200Z 000007000000010011200 3000000004100000 My question is why t-sql kill blanks
rm
New Member
New Member

--
27 Jul 2010 04:22 AM
What kind of process? Which t-sql statement you use?
Zoran, Jagodina
New Member
New Member

--
27 Jul 2010 09:03 AM
Pardon, I omit sql query when do T-SQL -- Create a table to hold the data CREATE TABLE #textfile (line varchar(8000)) -- Read the text file into the temp table BULK INSERT #textfile FROM 'c:\A.TXT' GO -- Now read it SELECT * FROM #textfile -- And then clean up DROP TABLE #textfile GO
Zoran, Jagodina
New Member
New Member

--
27 Jul 2010 09:05 AM
My original question is on http://www.simpletalk.com/community...93648.aspx where can see what is my question
rm
New Member
New Member

--
27 Jul 2010 10:06 AM
Can't connect to that link. Tried with data type char(8000)? Is it on sql2k8?
Zoran, Jagodina
New Member
New Member

--
27 Jul 2010 12:32 PM
Try http://www.simpletalk.com/community...93648.aspx to see my origin question (link work) Thanks for replay
russellb
New Member
New Member

--
28 Jul 2010 05:25 AM
1. Link doesn't work
2. If you want our help, post the question here, not links to another site.
Topic is locked

Acceptable Use Policy