Search results for query: *

I have the same problem. But it's after 64 records. My import file has 42k rows. But it doesn't keep going. It just stops and returns me to the command line prompt. Any ideas? Thanks! Mark

No, sorry. I finnaly gave up, I'm afraid to say. Best of luck! Mark

...> 24 then '25_' END as Span, CUSTOMER_LIFETIME_TOTALS.OCCURRENCE_1_TRANSACTION_DATE as Rcncy, CASE WHEN TRUNC(30*MONTHS_BETWEEN(SYSDATE, CUSTOMER_LIFETIME_TOTALS.OCCURRENCE_1_TRANSACTION_DATE),0) <= 30 then 'Last Month' WHEN TRUNC(30*MONTHS_BETWEEN(SYSDATE...

I'm getting the above error in a query. How can I 'trap' this error, and basically ignore it? Many thanks, Mark

Thanks! That's great - it hits the spot perfectly! Don't know how I missed that in the help file... If I can be cheeky and ask a follow on question: In the Macro I'm writing to go along with this sheet, I need to access data in several workbooks. I planned to do this by using: Dim R1 As Range...

Hi - I need to be able to change the name of the Worksheet, ideally by reference to the content of another cell. EG: =SUMIF([atvwk15.xls]storerep!$B$2:$B$201,$A$2,[atvwk15.xls]storerep!$D$2:$D$201)/SUMIF([atvwk15.xls]storerep!$B$2:$B$201,$A$2,[atvwk15.xls]storerep!$C$2:$C$201) In the above...

Thanks for this. It's interesting. But I don't think it solves my problem. I did try it, but one of my required settings is &quot;Obtain IP/DNS Automatically&quot;, and selecting this just deleted all the IP entries I set up through the 'add IP address' interface. Thanks anyway. Cheers, Mark

I have to plug my laptop into various different client offices. Each one requires a different set of IP/Router/DNS settings. At the moment I manually change them each time. What a bore! Can I store muptiple IP settings, and switch between them on the fly? Many thanks for any help. Mark Lewis...

I have a problem. My web developer insists that their Websphere v3.5 can only produce referer logs seperate to the main web logs. In my (limited!) experiance, a web log is typically: User IP| Date/time| GET statement| refering page/key words The seperate referer logs I am getting from...

I need to access a Windows system via Terminal services from an office of Mac's It seems you can get software to do this for OS-X, but these Mac's are all on OS-9. I can't find any TS software for OS-9. Does anyone know how this can be done? Many thanks, Mark

I'm having trouble with DIV/0 errors. I can't filter this out in the HAVING clause as the whole role row will go, and there is data in other columns I need. Someone suggested using DECODE, which seemed a good idea, but I can't get the syntax right for this query. The particular statement that...

...as Starters, count(case when DM2_EMPLOYEE.DATE_OF_TERM >='1-Jan-2001' then DM2_EMPLOYEE.DATE_OF_TERM end) as Leavers, Leavers/HeadCount * 100 as Churn, avg(case when DM2_EMPLOYEE.DATE_OF_TERM >='1-Jan-2001' then trunc(months_between(DM2_EMPLOYEE.DATE_OF_TERM...

...as Starters, count(case when DM2_EMPLOYEE.DATE_OF_TERM >='1-Jan-2001' then DM2_EMPLOYEE.DATE_OF_TERM end) as Leavers, Leavers/HeadCount * 100 as Churn, avg(case when DM2_EMPLOYEE.DATE_OF_TERM >='1-Jan-2001' then trunc(months_between(DM2_EMPLOYEE.DATE_OF_TERM...

I managed to sort out most of my porblems in the end. Initially, I tried every admin apssword I thought might be relevent - but to no avail. Finnaly, I tried Administrator with the password from my personal user account - it worked! I have no explanation for this. This has given me full admin...

Thanks for this. I'm away for 2 weeks now. I'll try on my return. Cheers! Mark

My 'Other user' is definatley a domain user. When you say 'joined to that domain' I take it you mean physically connected to (or dialled into) that domain's server? If I can set this up, will my laptop detect that I am connected to this domain, and accept my domain user/password? If so, this...

Well, It looks like I'm done for! The new user that was created for me (why? should have been same user, different config...) doesn't have Admin rights. Isn't there a way to log back in as my other user? It should still be there I presume, I just don't how to access it. I suppose if I...

Thank you both for your replies. I'm using Win2k Proffesional. No, I don't need to log back into the office network (I've left that company - bought the laptop), its just my user on that domain (locally on my laptop) has all my files/configurations/authorities, which I relly need to get back...

I was trying to set up a peer-to-peer to share files at home last night, and changed my Network Indentity from a domain to a Workgroup (which is what Help said I needed to do). This didn't help me to share the files, but has completely messed up my laptop by creating a new user and locking me...

Thanks for the lead! I'll go and check this now. Cheers!! Mark