Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. khsaunderson

    Mailto link in email opening wrong email

    Ok, thanks - I'll give that a go Kate
  2. khsaunderson

    Mailto link in email opening wrong email

    Yep, that is already the case - the old email addresses aren't even listed in the accounts bit. That's why it's so weird. Normal composing, sending, replying and forwarding works fine - it's only when you click an email link within an email that has been sent that the old email somehow pops up.
  3. khsaunderson

    Mailto link in email opening wrong email

    Thanks for the options, but I'm afraid neither worked. Aich69 - The signatures listed are only for my current email address. ChrisHirst - In the Profiles there is only the default Outlook one. Re the question from 58sniper, the current account with the correct email receives the email with...
  4. khsaunderson

    Mailto link in email opening wrong email

    Hi I used to have my Outlook set up so that I had 2 different email addresses to choose from. Now both of those emails/accounts are redundant and I have a new pop3 email address set up. When I click to compose a new email it all works fine, however, if I click a hyperlinked/mailto email link...
  5. khsaunderson

    ROW_NUMBER() OVER(PARTITION...

    Hi Yes, that worked like a charm. Thanks so much Kate
  6. khsaunderson

    ROW_NUMBER() OVER(PARTITION...

    Thanks for this. I had to make a small change, by adding a grouping to the end of the function: SELECT PACK.PAROCD, PACK.PACACD, COUNT(PACK2.PAROCD)+1 AS SEQ FROM PACK LEFT OUTER JOIN PACK AS PACK2 ON PACK2.PAROCD = PACK.PAROCD AND PACK2.PACACD < PACK.PACACD GROUP BY PACK.PAROCD...
  7. khsaunderson

    ROW_NUMBER() OVER(PARTITION...

    I am trying to write a bit of SQL in Access where I get a sequence dependent upon a field, eg ROCD CACD SEQ 0001 0001 001 0001 0002 002 0002 0001 001 0003 0001 001 etc I've tried writing a row over partition, but I keep on getting an error saying "Syntax error (missing...
  8. khsaunderson

    Find string anywhere in dbf tables

    Just tried out Agent Ransack and it worked like a charm - thanks :)
  9. khsaunderson

    Find string anywhere in dbf tables

    Hi I'm migrating data from an old dbf database and need to only migrate certain info. I'm looking for a specific string, so that I migrate the info from the correct table. Rather than searching through every table (over 200 of them), is there any way I can use SQL to find the string in the...
  10. khsaunderson

    Sequence

    Any help on how I would code the trigger?
  11. khsaunderson

    Sequence

    I'm using DB2 on an AS/400, so I guess that won't work then?
  12. khsaunderson

    Sequence

    Thanks. For some reason I am getting an error though SELECT CATALOGUE, ROW_NUMBER() OVER(PARTITION BY CATALOGUE ORDER BY CATALOGUE) AS SEQ FROM HPINCFL When I run this I get the following error: SQL0104 - Token ( was not valid. Valid tokens: , FROM INTO. Any idea why this might be? Thanks
  13. khsaunderson

    Sequence

    I am trying to insert a sequence into a table, but want to cycle the sequence dependent upon a specific field. CREATE SEQUENCE TEMP_SEQ AS DECIMAL(5,0) START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CYCLE CACHE 4; INSERT INTO Table (Catalogue char(27), Sequence decimal(5,0))...
  14. khsaunderson

    Divide 2 counts

    Thanks Frederico, I did have to make one change to this though, as I did before, as the result returns 0 unless the case statement is CAST as a decimal. (I also multiplied by 100 to get the percentage). SELECT (COUNT_SALMATCH / TOTAL_COUNT)*100 FROM ( SELECT CAST(SUM(CASE WHEN...
  15. khsaunderson

    Divide 2 counts

    Ah, so I had the WHERE clause in the wrong place. Thanks. However, because both counts were integers, I actually had to CAST one of them as a decimal. My final statement was... SELECT (C1/C2)*100 FROM (SELECT CAST(COUNT(*) AS DECIMAL) AS C1 FROM TABLE WHERE SALMATCH = 'N') T1, (SELECT...
  16. khsaunderson

    Divide 2 counts

    I have tried SELECT C1/C2 FROM (SELECT COUNT(*) FROM TABLE WHERE SALMATCH = 'N' AS C1 FROM SYSIBM.SYSDUMMY1) T1 ,(SELECT COUNT(*) FROM TABLE AS C2 FROM SYSIBM.SYSDUMMY1) T2 and SELECT C1/C2 FROM (SELECT COUNT(*) WHERE SALMATCH = 'N' AS C1 FROM TABLE) T1 ,(SELECT COUNT(*) AS C2 FROM TABLE)...
  17. khsaunderson

    Divide 2 counts

    How do I divide by 2 counts in DB2? It should be so simple, but I can't figure it out... (SELECT COUNT(*) FROM TABLE WHERE SALMATCH = 'N')/(SELECT COUNT(*) FROM TABLE) Thanks :)
  18. khsaunderson

    Auto increment insert error

    I have answered my own question... Start by creating a sequence... CREATE SEQUENCE TEMP_SEQ START WITH 297016 INCREMENT BY 1 MINVALUE 297016 NO MAXVALUE CYCLE CACHE 4; Then use the sequence in the insert... INSERT INTO MAIN_TABLE (TUNCODE, TUNTYPE, TUNCONT, TUNTITLE) SELECT...
  19. khsaunderson

    How to auto increment a field?

    I am trying to insert into a table and need to add to an ID field that is auto incremented by a Cobol program, so I need to replicate this in my SQL script. Eg, INSERT INTO Table (ID, Name) SELECT xxxx, ISRC FROM TEMP_ISRC Thanks :)
  20. khsaunderson

    Auto increment insert error

    In the example below the first 3 columns are the unique identifier, and the 4th column contains the data. The TUNCODE is an auto incrementing field (hence it is commented out). INSERT INTO MAIN_TABLE (--TUNCODE, TUNTYPE, TUNCONT, TUNTITLE) SELECT '1', --TUNTYPE, '0000000', --TUNCONT...

Part and Inventory Search

Back
Top