Viewing 15 posts - 961 through 975 (of 1,195 total)
Nice straight forwards QOTD - thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
August 8, 2012 at 9:16 am
Got me thinking - good question.
Thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
August 2, 2012 at 3:57 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
July 24, 2012 at 9:19 am
SQLPhil (7/24/2012)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
July 12, 2012 at 2:25 am
Good question - thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
July 11, 2012 at 2:43 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
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
July 10, 2012 at 9:18 am
anthony.green (7/10/2012)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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 punch as well as...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 17, 2012 at 2:54 am
Definitely had to earn my point today - took a fair bit of thought.
Good question, thank you
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 13, 2012 at 12:47 am
Another question from Steve on contained databases. I wonder what he has been playing around with?
😉
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
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
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 5, 2012 at 8:40 am
Viewing 15 posts - 961 through 975 (of 1,195 total)