Search results for query: *

I have a script that runs a program with an interactive user parameters screen. In order to run this as a CRON job 'we' have created a script that passes the key depressions to the job. The trouble is the CRON job is "blind" so any on-screen messages that may have occured during an interactive...

Hi, The system we are using has a unique date identifier rather than using a recognised date format. I need to convert this date into a "DATE" format field so that the reporting tool (Business Objects) can work with it. I tried to create a lookup table with a field 'date' in it using the...

Hi, I'm trying to identify where some records may be missing from a file using a shared key field. For illustration tables 'movements' and 'ledger' should both have records for every movement with a key value of 'journal' To show all details I would use sql: select * from movements, ledger...

Hi, I have the need to sum a value in a query with a join. For example: I have Stock table including Cost of Item Sales table including Item and Sales Vales I want to show: Item, Sum(Sales Value), Sum(Cost) When I define Cost and Sales Value as measures without sum() in the Universe all is...

Hi, I'm looking for a simple statement to conditionally replace a value. I have a value field that could be negative or positive depending on a Debit/Credit field. Thus I need to query something like: select {IF type = "debit" THEN value ELSE value * -1} from table Obviously the...