Search results for query: *

Hi I have a grant to do a training course after being made redundant - but I can't decide what the hell is the wisest thing to do!! I have some database oracle admin experience (setting up database, importing, cronjobs), some business objects experience (admin, security, report writing) and a...

hi I have a problem with my materialized view on my replicated database- its taking about 20 hours to update every day! I've noticed it does a COMPLETE refresh every day and want it to do a fast refresh but I need to implement a log for this I've read....the DBAs for the live master database...

Hi i need to count the number of people who are logged in over and including 3 minutes eg user a logs in at 9:00 and logs out at 9:05 user b logs in at 9:00 and logs out at 9:01 user c user a logs in at 9:00 and logs out at 9:03 from example above that would be users a and c! the row data...

Hi all This query takes WAY too long to run (over an hour) - can anyone think of any other way to write it please?!! SELECT to_Date((to_char(A.ADDATE,'dd/mm/yyyy')||' '||A.ADTIME),'dd/mm/yyyy hh24:mi:ss'), B.ACCOUNTID, A.CAMPAIGN, ( C.TITLE ), A.WEEK, C.TITLE, D.TITLE FROM A, B, C, D, E WHERE...

Hi I have this following SQL statement where tables can join in various ways but I cannot get the data to return when I add in the last join The sql is as follows SELECT PURCH_ORDER.ACCOUNTID, PURCH_ORDER.ORDERDATEELEMENT, PURCH_ORDER.TOTALRATEDAMOUNT,PURCH_SUBSCRIPTION.FREQUENCY...

Hi I'm trying to count the number of people watching TV at a specific minute in time (well I need to do it for every minute in an entire month!) My data shows when people started and stopped watching TV- so I need to check for every person when they started watching it and whether they shud be...

Hi I've been banging my head against the wall for this one for way too long so I really am hoping someone else can see a solution for me! To start with here is the base data...there are 4 scenarios I am trying to cover in my sql query and the rows below cover all 4 create table cdr (...

hi is it possible to change the universe connection of an existing report that is based on a query from a different universe? I can't do it in 'Set Datasource Location'- possibly because the report is based on a query on another universe! i don't want to have to rewrite the query for the new...

I had a local version of Crystal Reports Server XI(v 11.5) and Crystal Reports XI Rel 2 running standalone on my PC to evaluate it. However we moved onto a new office domain recently and my computer name has changed- lets call this 'NEWNAME' - and it has caused me loads of problems with my...

Hi, Can someone tell me if its possible to loop through all of the controls on a form so I can tell if the user has entered any text in any of the textboxes/comboboxes etc? I'm having a problem that when one user saves a particular record and then another user access that record and changes...

DROP TABLE #temp CREATE TABLE #temp ([User] nvarchar(100)) INSERT INTO #temp SELECT [User] FROM tblStatsUserDetailed GROUP BY [User] DECLARE @StatsDate nvarchar(10) SET @StatsDate = 'SQL' ALTER TABLE #temp ADD @StatsDate nvarchar(10) null I'm basically trying to add the column name 'SQL' to...

Is it possible to run a macro in a data access project from a DTS package My problem is... the DTS package rebuilds the data access project daily but when this completes I need to send reports out As you can't link to reports in the DTS I have to manually open up the data access project and...

I have a table which gives me a bill amount on a certain date but there is no balance as at any given date. I need to take an account eg account no = 60000120 Then I need a running sum of all the balances up to today eg AccountNo TransactionDate Amount 60000120 19/01/2001 200 60000120...

is it possible??? I need to send out reports via email to teams . The Attachement on these emails are reports I have created in the Data access project and I need to send the exact format. Is there any way to do this automatically via the DTS- I know I can do it via a macro but that's no good...

I am trying to use a date field input on a Data Access Project form as a filter for opening a report, but this only works when the date is in American Format ie. mm/dd/yyyy. I am based in the United Kingdom, and would prefer not to have the format of the field on my form set as American, so is...

I was wondering if anyone could help me with the following VB code attached to an Access form text box. The point of the code is to include weekends and bank holidays when you're counting 8 working days from a certain date(the date in the text box-txtD0301Sent) My problem is I can't get the...