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 Rhinorhino 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
  • Content: Threads
  • Order by date
  1. 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.
  2. 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.
  3. 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
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. Naith

    Update performance

    Is there a more efficient way to perform this update? UPDATE TSR_Forecast SET TSR_Forecast.fc_sales_district_id = b.sales_district_id FROM TSR_Actuals b WHERE TSR_Forecast.customernumber = b.apple_hq_id AND fc_sales_district_id IS NULL and sales_district_id <> 'SP20' At the moment, despite...
  10. Naith

    Truncate speed

    Hey guys, On SQL 8, I have a table with around 500k rows. The table has one key, a clustered index, and a few other indices. Yet a truncation takes over two hours. Why would a truncation take this long?
  11. Naith

    Change of total after insert

    Hey, I'm doing a straight insert from one table to another with no where clause, and am noticing that the totals of each measure in both tables are different, when I would expect them to be the same in either table. INSERT INTO TableA (Sales_Org_ID, sales_org, pl2_classid, pl2_class...
  12. Naith

    Day of week

    Hi, What's the function to return the longname of day of week? (SQL 8) i.e. 'Thursday'
  13. Naith

    Joins strangely affecting data...

    Hi, If I run the following, I get no data: SELECT * FROM TSRDB WHERE TSRDB.TrueSalesOrg = 'FRANCE' AND TSRDB.Class = 'IBOOK' AND TSRDB.TruePPN = 'PPM9623' AND TSRDB.TrueAppleID = '53326' However, if I join this table to some other tables to increase the columns returned, like this: SELECT <some...
  14. Naith

    System overiding joins

    Hey guys, Take a look at this for me, and tell me if you have any ideas. I'm on XI 2, on SQL 2000, developing a report querying 7 tables on one datasource. The query approach is a spider one, with one key table left outer joining to the other 5, and one equi-join on primary/foreign keys...
  15. Naith

    How to case update

    Hi, I want to update one of 13 columns in one table. Which column is to be updated depends on the value in another table. In essence, if the value in the source table is 'C', then I want to take the third measures column from this table and update the third measures column in the target table...
  16. Naith

    The log file for database 'tempdb' is full.

    Hi, I'm attempting to execute a fairly large insert, and coming up against: Server: Msg 9002, Level 17, State 2, Line 3 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space. The statement has been terminated. At first, I thought...
  17. Naith

    Summarising vs lifting values

    Hi, I am attempting to take data from a table and summarise it in part in a view. The reason for this is to denormalise the weekly rows over columns, replacing twelve weekly rows with one row with twelve weekly columns. The relevant section of code looks like this: ... sum(Case When...
  18. Naith

    Backup Database Failure

    Hi, I'm trying to do a one off backup my db, thusly: USE Reseller2 GO BACKUP DATABASE Reseller2 TO DISK = 'E:\Reseller2' WITH FORMAT, NAME = 'ResellerBackup20060721' GO where E:\ is an external drive. (The space on C:\ is limited, and there is no partition.) The backup fails with the...
  19. Naith

    Insert works in SQL but not in SP

    Hi, When I execute an insert into a table in Analyzer, along the lines of this: SELECT cast(Sales_Org_ID as smallint), sales_org, pl2_classid, pl2_class, convert(decimal(18,1),right(fquarter,4) + '.' + left(fquarter,1)), ( case when convert(int,round("fweek",1)) >= 10 then...
  20. Naith

    Creating a simple view from a sproc

    Hi, I'm coming from a different rdbms school, and new to SQL Server. I was wondering how it's possible to create a view in a stored procedure, passing a parameter value into it assigned from another stored procedure. Thanks

Part and Inventory Search

Back
Top