Viewing 3 posts - 1 through 3 (of 3 total)
Thanks re number of characters.
as for the select - I have two select statements,
I tried adding
select td = Select Row_Number() Over(Order By snapshot_Date) %...
February 24, 2017 at 8:38 am
turns out the problem was the date field on each row.. wasnt being recognised as datetime therefore would not import
changed process to import into a temp table with...
February 23, 2017 at 2:11 am
doh... I had posted the wrong .fmt file.... now corrected
I tried changing to tab to see if it made any difference..... but it didnt
February 20, 2017 at 7:32 am