Viewing 15 posts - 1,231 through 1,245 (of 3,543 total)
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value
Most common reason is the default language setting on your logins as this...
August 12, 2010 at 6:46 am
This is 'a depends' answer.
You can use either, if all the csv files are of the same format then you could BULK INSERT to a staging table before transfering to...
August 12, 2010 at 6:28 am
giosermao (8/10/2010)
Please receive my sincere and more than eloquent thanks.
Your welcome.
and thank you for yours 🙂
...made me think that we need to do things better, I want to change...
August 11, 2010 at 3:27 am
Notwithstanding the comments already made, I believe this is what the translation of your query would look like, ie trying use the IN predicate on a column value.
SELECT s.StatusID +...
August 10, 2010 at 2:13 am
skcadavre (8/4/2010)
Jack Corbett (8/4/2010)
August 4, 2010 at 9:58 am
Jeff Moden (8/3/2010)
Same here... I just don't want to become an Oracle DBA. 😛
Shame Jeff,
I'd love to see the Pork Chop launcher backfire 😉
August 3, 2010 at 7:24 am
Steve Jones - Editor (7/16/2010)
Kit G (7/16/2010)
The Dixie Flatline (7/16/2010)
It was a dark and stormy night....As I sat down to write...
I was quite a sight...
That you're all wrong and I...
July 17, 2010 at 10:03 am
Tom.Thomson (7/15/2010)
The post from David Burrows was far from the total fail you claim.
Thanks Tom 🙂
I think this thread is on the slippery slope to oblivion 😉
July 15, 2010 at 6:51 am
Any ideas you have for bumping up membership, I'm all ears.
Yeah, pay for my time off work and the flight across the pond and I'll join. 😀
Wish I could have...
July 15, 2010 at 6:48 am
doobya (7/15/2010)
in VB6 you can control whether a given block of code is resumptive or not
Not entirely true, it 'depends' on the definition of 'a block of code' and where...
July 15, 2010 at 6:43 am
doobya (7/15/2010)
VB6 is a good example, because you can use.....
You seem to have a singular point of view in that no one agrees with you.
On Error Resume Next
I would like...
July 15, 2010 at 5:40 am
Excuse the caps but I am getting frustrated when people are missing such a simple point
No one is missing the point. TRY...CATCH does exactly what you describe, it catches...
July 8, 2010 at 2:07 am
Tom.Thomson (7/7/2010)
David Burrows (7/7/2010)
However the first programming language I used was CESIL (the version from the late 1960's) 😎
CESIL? :Wow: Good heavens! And you went into computing after that?...
July 7, 2010 at 6:57 am
Tom.Thomson (7/6/2010)
David Burrows (7/6/2010)
Tom Brown (4/23/2010)
EDSAC !My word - that was ancient history when I started on ICL 1900s
Not that ancient when I started on an Elliott 803 !!
Elliot...
July 7, 2010 at 2:02 am
Tom Brown (4/23/2010)
EDSAC !My word - that was ancient history when I started on ICL 1900s
Not that ancient when I started on an Elliott 803 !!
July 6, 2010 at 6:45 am
Viewing 15 posts - 1,231 through 1,245 (of 3,543 total)