Search results for query: *

Hi All, I want a formula which will be datefield - datefield - workdays - any ideas? Cheers Sam

Hi all, I want to ammend a report in V7 which currently reads FieldA = Date(YYYY, MM, DD) -- and has a fixed date. to say FieldA = CurrentDate what is the correct way of doing this as I keep getting an error relating to needing a string! Many thanks Sam

Hi All, I know in Toad you can view the creation script of a view is there any way of doing this in sql plus? Cheers Sam

Hi All, What does the != function do? Cheers Sam

HI All, Realise this is a really dumb question, but I want to find a table where table_name like '%BLAH%' how do I do this? Cheers Sam

Hi All, Just converting a script someone else has written, am confused by the use of this ~ symbol?? What does it do?? Cheers Sam

Hi All, I'm curious to know if anyone has tried scheduling crystal reports to run either with v10 or using Enterprise? Many thanks in Advance Sam

Hi All, Please help, the subreport I've created brings back a few pages of data, the data does not start to display until page 2. Is there anyway of forcing it to start on page 1? Many thanks Sam

Hi All, I've set up a script that runs 3 seperate select statements. At the begining of the script there is a title using Ttitle left 'sadljkfdlk'. The title only appears above the 2nd set of results - any ideas why this is? also is it possible that I could have a different title for each of...

Hi All, I have a script where the results look as follows B C D row1 1 3 6 row2 row3 4 5 6 How could I ammend my query to not show row2 as there are no results for this row??? Many thanks Sam

Hi All, I have a select query grouped by name, then area for example I want to have a 3 counts, 1 for those created less than 25 days, then 35 days then 56 days, is it poss to do this with a decode statement? e.g. DECODE(count(created_date between sysdate -25 and sysdate) ...

any ideas why I can't use this update statement? update sb_void_offs set offcount = blah (Select pro_propref, count (oof_refno) blah FROM sb_void_offs, organisation_offers WHERE pro_refno = oof_pro_refno(+) AND oof_offer_date BETWEEN voiddate AND letdate group by pro_propref...

Hi All, Below is my script, I need to find the avg no tot_offers made between the 2 dates as per my subselect, I cannot use the b. and a.vev_event in the subselect, any ideas? SELECT AVG (TO_DATE (b.vev_event_date) - TO_DATE (a.vev_event_date)) aver, MAX (TO_DATE (b.vev_event_date)...

Hi All, Any ideas how to change the path that sql plus auto picks up for starting e.g. @ script? Cheers Sam

Hi All, Whats the simplest way to count the number of days between to dates? Many thanks Sam

Hi All, I'm having problems with the following code, my results are bringing back more than 1 a.vin_refno per a.vin_pro_refno any ideas? many thanks Sam SELECT a.vin_pro_refno, MAX (a.vin_refno), vin.vin_hrv_vcl_code, vin.vin_vpa_curr_code FROM void_instances a...

Hi All, USed to Crystal 8.5 Dev, any quick tutorials to get to know Oracle Reports? Cheers Sam

Hi All, Below is my script - can you see any obvious errors, its to update 4000 records I left it running for 2 hours - it should only take 20 mins max:- update sb_void_losses set sb_tot_rentloss = (Select sum(vtr_dr) from void_transactions v1...

Hi All, Sorry for being a pain, I need to do an update script as below and insert the sum I'm retrieving when I run the script below I get the error group function is not allowed here, any ideas? Many thanks Sam UPDATE sb_void_losses SET sb_tot_rentloss =SUM (vtr_dr) WHERE sb_prop_ref IN...

Hi All, If your doing an update where = to select from etc, if the table has outer joins does this cause problems? the code I have written doesn't seem to work and If I restrict to 1 record, it updates all records with the same 1 row instead of only updating one record. Any ideas where I'm...