Viewing 15 posts - 421 through 435 (of 702 total)
Here's a shoot-from-the-hip response first: You can get this sort of error by specifying a numeric value for comparison with a character type column in the WHERE clause. If...
July 30, 2009 at 8:19 pm
"English as a Second Language" ends up as ESL, so I guess "English as a Third Language" would be ETL. Use that accronym for it in this crowd and you'll...
July 29, 2009 at 3:45 pm
I'm wondering if I should have chimed in on this problem. Perhaps someone here who's dealt with transferring data from dBase to SQL Server can help. The...
July 28, 2009 at 8:01 pm
I'm not familiar with dBase, but it looks as though it must allow the bad data in a field/column that it has identified as a date (else, where would MS...
July 28, 2009 at 7:55 pm
Steve Jones - Editor (7/28/2009)
How about advanced pork chop aiming strategies for maximum developer damage?
Just be careful of starting an internecine battle. There are more of we developers in...
July 28, 2009 at 12:31 pm
If the source date information is in a "free text field", I would think that would mean it's simply a string. Yet, you're getting some error about converting DBTYPE_DBTIMESTAMP....
July 28, 2009 at 12:16 pm
If the legacy app data doesn't conform to the expectations of the CAST or CONVERT for a datetime, then those functions cannot work. SQL has to be able to interpret...
July 27, 2009 at 8:02 pm
Your first query will return a set of "create_time" values, but the SELECT list does not have any identifier by which you would know which ticket had which earliest value....
July 27, 2009 at 1:07 pm
One: You do not need to use a cursor to get data back in a specific order. Here's your data loaded to a temp table and a query...
July 24, 2009 at 6:47 pm
I don't think you need to do anything special for the length of the number in the varchar unless there's somethnig else followinng the number. I just ran this...
July 24, 2009 at 2:08 pm
I'm not sure where the other responses here are coming from. You've actually got two main points to fix:
1. The format for defining a decimal datatype has the...
July 24, 2009 at 1:53 pm
Just got back from two week trip, so am skipping through the Thread. Sorry if this is a repeat SF suggestion for younger readers, but have to make sure...
July 23, 2009 at 3:32 pm
Really, really bad form on that table. Can you normalize it?
Karthik,
In other words, think about what you'd have to do if another country were added to the mix. ...
July 23, 2009 at 2:57 pm
Re: Lynn and Eswin...
Ah, my goodness. I don't think I could have invented a more clear case for the importance of careful use of punctuation. There's a book that...
July 3, 2009 at 10:57 am
name="knownAsteroids" class ="Asteroid">
... 40 or so lines of xml
$beliefbase.getBeliefSet("known_asteroids").size()>0
A tiny part of me of which I am not proud was glad to see this....
July 2, 2009 at 3:09 pm
Viewing 15 posts - 421 through 435 (of 702 total)