Search results for query: *

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.

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

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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