Recent content by lambic

Thanks guys - will give both suggestions a try (the database is Ingres by the way). Cheers

Hi, I have an to write an update query, based on dates, which I can't quite figure out. The details are: Table A: AccountID DateFrom DateTo Value Table B: AccountID DateFrom DateTo Value What I need to do is update Table A Value with the Value from Table B where the AccountID's match and the...

Thanks Synapsevampire. Have managed to sort it now with your help. Cheers

Hi, Im using Crystal 10 with a SQL Server 2000 Database. I have a table which contains one or more records for a given record ID field. Each record has address line columns, Address1 - Address4, and 3 boolean fields to indicate what type of address it is, Type1, Type2 or Type3. The address can...

Have managed to sort it out - with your help. Thanks for taking the time out to help guys. Cheers!

Hi, I am trying to write an update query without much success! I have the following 2 tables: TABLE_A Account_ID Sub_Account_ID Sub_Account_Adj Issue_Flag TABLE_B Account_ID What I need to do is set the Issue_Required_Flag from 0 to 1 in TABLE_A where the Account_ID exists in TABLE_B, but...

Thanks guys. I think the macro code would be ideal, the serial number is just a number so should be fine. I'll give it a go. Thanks again

Hi there, I was hoping somebody may have some advice on the following: I want a user to be able to run a batch of mail merge labels in MS Word 2000. The labels contain a sequential numeric code which increments by 1 on each label. I can achieve this easily emough using Excel as a data source...

Hi, No, I haven't checked that option. I just tried the export with it checked, but it failed with a 'failed to set user permission' error. Basically I just want to copy the data into a replica database on a weekly basis, for reporting purposes. I'm not using the SQL replication function as I...

Hi, In SQL server 2000 - I'm attempting to copy data from tables in database A to database B. Database B is an exact copy of database A and is on the same server. However, if I use the DTS Import/Export Wizard, choosing 'Copy objects and data..' and 'Copy data - replace existing data' the copy...

Thanks guys - problem sorted now. Cheers!

Thanks to the both of you - will give it a try Cheers!

Hi, Thanks for that guys. I didn't explain propertly that what I don't want to insert into the table is a record that has the same account_no & reference_no combination as a previously inserted record. The second insert can pick up the same account_no, but I only want to insert it if the...

Hi, I have a problem with an insert, basically I've populated a table (say table_a) with records based on one criteria, and have to then insert records into table_a based on another criteria, but only if they don't already exist in table_a. E.g. insert into table_a (account_no, reference_no...

Doh! My mistake - sorry!