Search results for query: *

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!

Hi lbass, Thanks again for your help. I've done what you suggested & created a SQL command to get the total record count (which works fine), then embedded that into the sort formula. However, it now doesn't work for some reason (data is now in same order as the table). My sort formula is...

Thanks very much for that lbass, it works great. Do you know if its possible to dynamicaly calculate the number of pages in the sort formula, so that if there are a varying number of records when the report is run, I don't have to edit the sort forumla? Many Thanks

Hi, I have a requirement to produce some address cards using Crystal Reports 10 Professional, using data from a MS SQL Server 2000 database. The cards need to be printed 4 up on A4 in landscape, which I have set up with no problem, however they need to look someting like this (example using 12...

Hi, Basically I need to write a script which will take a fixed length text file, read each record & split it at a certain point, adding a character looked up from the array (the subscript will be a field in the record), then joining the split record again and outputing to a new file. Example...

Thanks. I've realised that I've posted in the wrong forum, as I'm using NAWK to develop this script! I'll repost in the correct forum.... Sorry guys.