Viewing 15 posts - 52,396 through 52,410 (of 59,064 total)
Simong,
Here's a simple "splitter" to normalize the CSV entries you have so you do a join instead of a "LIKE"...
--===== Create a table to hold user ids and a word...
February 20, 2008 at 4:38 pm
tbeadle (2/20/2008)
[font="Arial"]There are word token subroutines available to help with loading the single field table.The comparison of the two table entries would be fairly simple at that point.[/font]
Good thoughts, Terry......
February 20, 2008 at 4:12 pm
Either way, looks like a correlated sub-query is going to be involved which is why Matt suspects the performance is going to suck a bit...
Here's another way (output could be...
February 20, 2008 at 3:42 pm
Ya gotta make one...
--===== Create and populate the Tally table on the fly
SELECT TOP 11000 --equates to more than 30 years of dates
...
February 20, 2008 at 3:09 pm
Matt Miller (2/20/2008)
Would this have anything to do with using Native format (as opposed to character format?)
Man, I can't wait to get off this cold medication... I totally missed that...
February 20, 2008 at 2:49 pm
Dang... I was loading up the double-barreled pork-chop sling-shot. 😉
February 20, 2008 at 1:25 pm
I'm with Michaeal... I'm not sure anyone would have entries for, say, 1754, or even 1901 and certainly not for the year 2100 or 2200. What I'm trying to...
February 20, 2008 at 1:12 pm
No... if you don't specify the database or the server, it assumes the "default" database for the user (which has been nicely overcome by the 3 part naming convention) and...
February 20, 2008 at 1:09 pm
I've never seen BCP do such a thing... what are you using to call the BCP with?
February 20, 2008 at 12:46 pm
I don't know what it is... everything in the command you printed looks fine. I even tried it with substitution of colums, etc, and it works just fine on...
February 20, 2008 at 12:42 pm
Huh... looks like you've done everything correctly... what are the clunky characters and are they always the same or not?
February 20, 2008 at 12:05 pm
Susane, Matt is spot on... you won't find a faster way to do that especially in light of a million rows or so, in my humble opinion.
Undoubtedly, you will run...
February 20, 2008 at 11:57 am
Lynn is spot on.
Just to expose another conversion method that's all math and nothing character based...
[font="Courier New"]UPDATE MyTable SET xyz_new = SELECT DATEADD(yy,XYX-1900,0)[/font]
Sounds obvious, but make sure that step 2...
February 20, 2008 at 11:33 am
It seems there's a bit of confusion here...
First, when you create the text file, do you want it done automatically as part of a stored procedure or do you...
February 20, 2008 at 11:23 am
Viewing 15 posts - 52,396 through 52,410 (of 59,064 total)