Viewing 15 posts - 48,286 through 48,300 (of 59,064 total)
Grant Fritchey (9/15/2008)
September 15, 2008 at 10:11 am
Carla Wilson (9/15/2008)
Thanks for pointing out how...
September 15, 2008 at 10:05 am
Ummmm... wouldn't a nice partitioned view work well here?
September 15, 2008 at 9:50 am
Depends on what type of DBA you have (see previous post). And, again, it doesn't matter if you limit the people on the Dev box or not if you...
September 14, 2008 at 10:16 am
Sergiy (9/14/2008)
They are not from file, of course. 🙂
And, I believe, there are 7 columns in both strings.
1st one should be split into:
1Pick-up
2
3
41234
52008-08-24
6 "2008-08-24"
717", unknown...
September 14, 2008 at 10:04 am
Jack Corbett (9/13/2008)
Yeah, I know that it is turned off by default at the...
September 13, 2008 at 11:53 pm
Heh... yeah, it's an attention getter for sure.
Start by clicking on "Write for us" in the vertical column at the top left of this whole thread. Then, click on...
September 13, 2008 at 11:48 pm
I think 3 separate directories might be a bit of overkill, but if that works for you, good enough. 🙂
September 13, 2008 at 11:40 pm
I count 8 columns in the first line and only 7 columns in the second line. Is that correct? And, the single quotes on each end are also...
September 13, 2008 at 11:28 pm
But, that's the whole problem. Your code is loading the file names of the full files and that's not the right thing to do. Your code should only...
September 13, 2008 at 9:59 pm
Heh... good analogy... unless you don't realize that you're on the same team.
You guys need to sit down and hammer out your differences, not so that anyone wins but the...
September 13, 2008 at 9:43 pm
Greig,
When you get a chance... all I need to know is are you splitting a single parameter or do you need to split a whole column of these? If...
September 13, 2008 at 7:48 pm
Mike DiRenzo (9/13/2008)
Use the Tally table, join to it, then use intrisinc SQL functions because you will have postive indexes to work with. Good luck.
Who's that directed to, Mike?
September 13, 2008 at 7:45 pm
Absolutely... what do you want to do? Split a true CSV parameter or a tru CSV column in a poorly formed table that needs a bit of normalization? ...
September 13, 2008 at 7:32 pm
Viewing 15 posts - 48,286 through 48,300 (of 59,064 total)