Search results for query: *

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

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.

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...

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...

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

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...

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...

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

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...

Any help on how I would code the trigger?

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

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

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))...

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...

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...

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)...

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 :)

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...

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 :)

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...