Recent content by Naith

Beautiful. Thank you.

You have to right click the connector and select options, deactivate whichever data object types you don't need (tables/views/SPs), hit OK, and then refresh. I've missed these 'features'.

Environment: CR2008/Oracle11g Why is it that when I create a system ODBC connection to an Oracle database, in CR I only see about 80% of the database objects that the user owns? Using native drivers, the full schema is available.

Beautifully done.

Can one of you bright sparks display the logical way to convert these values: 2000 9999999 13 to 2 0 0 0 9 9 9 9 9 9 9 1 3 All source values are numerical, but naturally, it isn't essential that the formula preserve this.

Hi, Does anyone have a walkthru or tutorial of connecting to 10g via jdbc thin client? I've used the Oracle documentation, but am having no joy, and am unsure of which files need modification for jdbc. Thanks

Hi lynchg, Did you ever get to the bottom of this? -N

Essentially, it'll be the most recent chronological file in the source directory. However, seeing as the intended copy process is from local sheet to local sheet within the same workbook, if there's a solution which doesn't reference a file name, that would work.

That was quick. You guys are on the ball around here. Combo, thanks for your contribution, but that is a manual process. This needs to be automated, which is why I alluded to a macro. Skip, thanks for pointing me to the FAQ. My concern here is that I would have to explicitly name the data...

Hi, Is it possible to conditionally copy certain columns from an Excel worksheet to another sheet in the same workbook, removing any column gaps? e.g. Source: Worksheet A Col1 Col2 Col3 -------------------- Critical 1234 S.Smith Critical 1234 J.Black High---- 2222 B.Taggett...

Actually, it does say so in the initial post. So psychic powers not needed.

Actually, Chris, that doesn't handle a date ranged parameter over multiple days. Taupirho, I can only envisage working with your approach if I amalgamate both schedules into a temp table before applying your logic. Because of the fact that both schedules are derived in completely different ways...

Hey guys, Thanks for taking the time out to take a look at this. Both these options throw up some useful ideas. I like the rank notion, which I'd not thought about at all. I'll probably go with Mr Hunt, as it's closest to the road I'm already halfway down providing the performance doesn't come...

Thanks for your feedback. Okay guys - brace yourselves. This is a rudimentary, over simplified example of data. Schedule A (PRES) ---------- DATE PROGRAMME SCHEDULE 01/01/09 JAMES BOND A 01/01/09 REMINGTON STEELE A 02/01/09 JAMES BOND A 03/01/09...

Hey fellas, I'm currently in discussion with my team about how best to go at this business logic. This is a television media environment, where there are three schedules per channel. In order of priority; schedule A, B, and C. Let's say the user is interested in looking at a weeks worth of...