Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Naith
  • Order by date
  1. Naith

    Space Loop

    Beautiful. Thank you.
  2. Naith

    ODBC connectivity

    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'.
  3. Naith

    ODBC connectivity

    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.
  4. Naith

    Insert value every other character

    Beautifully done.
  5. Naith

    Insert value every other character

    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.
  6. Naith

    Connecting to Oracle via JDBC thin client

    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
  7. Naith

    Missing Records on Crystal Report from Notes View

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

    Conditional Copy Macro

    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.
  9. Naith

    Conditional Copy Macro

    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...
  10. Naith

    Conditional Copy Macro

    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...
  11. Naith

    Loop vs Temp Table

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

    Loop vs Temp Table

    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...
  13. Naith

    Loop vs Temp Table

    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...
  14. Naith

    Loop vs Temp Table

    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...
  15. Naith

    Loop vs Temp Table

    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...
  16. Naith

    Query Builder Wiz

    Hi guys, Not having used Enterprise for a while, I'm a little bit rusty. Does anyone know if it's possible to write a query in Query Builder 11.5 to extract records of reports which have been scheduled, exporting to email, where the email has failed even if the instance has not? Much obliged...
  17. Naith

    executing scripts from scripts causing hanging

    Hi, I have 7 scripts running back to back, each executing the next and passing a variable as each script comes to an end. 9 times out of 10, as the 3rd script tries to execute the 4th script, the process just hangs indefinitely. (The 3rd script is doing an insert, and then a multiple update of...
  18. Naith

    Normalising a denormalised dataset

    Union. Of course. Thanks for the kickstart.
  19. Naith

    Normalising a denormalised dataset

    Hi folks, I can't get my head straight on the best way to attack this situation. I have a denormalised table which looks like this: Country Product Week1 Week2 Week3 ------------------------------------- SPAIN CPU 190 200 280 ITALY CPU 800 877 788 The problem is I can't plot a dynamic graph...
  20. Naith

    Update performance

    I like the look of this. Seems to be a lot easier on the processing. Thanks. Have a star. -N

Part and Inventory Search

Back
Top