Viewing 15 posts - 961 through 975 (of 1,194 total)
Off the top of my head (not a lot of info to go on) create a temp / staging table then bcp / bulk insert the file and use substring...
July 24, 2012 at 9:19 am
SQLPhil (7/24/2012)
July 24, 2012 at 2:42 am
rodjkidd (7/12/2012)
..... Now looking forward to SQL in the City on Friday in London. . . .
Can't agree more - this will be the first time in three years my...
July 12, 2012 at 7:43 am
Henrico Bekker (7/12/2012)
Koen Verbeeck (7/12/2012)
But apparently some people still get it wrong.
Or maybe they just sneezed while picking the answer and thus accidentily clicking...
July 12, 2012 at 2:25 am
Cliff Jones (7/10/2012)
You guys have me all interested in coming to the UK to try all the fine Ales available there.
I'm sure you would be made more than welcome
July 10, 2012 at 10:31 am
Andy Hyslop (7/10/2012)
10 pints where consumed in the space of around 3-4 hours
/Tips Hat
Impressive!!
I'd be no good for anything after that!! :sick:
My days for that sort of thing are...
July 10, 2012 at 9:18 am
anthony.green (7/10/2012)
July 10, 2012 at 9:13 am
Two favourite ales of mine one found here
http://www.marstonsbeercompany.co.uk/our_brands/marstons/oldempire.asp
and the other here
http://www.innisandgunn.com/en/the-range/original.aspx
Not beers for drinking by the bucket full though - they pack a bit of a...
July 10, 2012 at 8:48 am
Good question today, thanks - took an educated guess and got it wrong.
Looks like I need more education.
April 17, 2012 at 2:54 am
Definitely had to earn my point today - took a fair bit of thought.
Good question, thank you
April 13, 2012 at 12:47 am
Another question from Steve on contained databases. I wonder what he has been playing around with?
😉
April 12, 2012 at 4:00 am
jfogel (4/5/2012)
SELECT'"'+Field1+'"' + ',' +
'"'+Field2+'"' + ',' +
'"'+Field3+'"' + ',' +
...
Fieldn AS TheOutput
FROM table
Wrap them in double quotes in case anything has a comma in it.
Good catch
April 5, 2012 at 8:40 am
Viewing 15 posts - 961 through 975 (of 1,194 total)