Recent content by Honyo

Hi Can anyone help me here. I have a SQL server (BCSQL1)that is linked to a remote server (DENSQL1). I have a query that I need to run that will go from BCSQL1 to DENSQL1, pull specific information from DENSQL1 and then insert it into a table on BCSQL1. I need all the current days data...

Hi I need to create a table that will store Global Address List information. We are running Exchange 5.5. and SQL 2000 Database = Intra Table = GAL Fields = UserName E-mail I need to create a script that I can schedule, that will go out and pull the relevant information (Display...

Hi When run without the "where left(Transaction_ID,1) = 1)" it works. It will check the local table, find the highest value, dump it into the @transid variable. It then goes to the remote SQL server and then uses the vaible to do a selct of all records that are higher in value. It...

Afternoon All, I deperately need some help here. I have SQL installed on 2 different servers DSQL and VSQL. I have a database called AVS with a table called Transaction_Info (on both servers). DSQL and VSQL are linked server via VSQL. I need to run a query that will check a column on VSQL...

Hi I thought of replication but it is too bandwidth intensive? Regards Honyo

I need to make sure that the files I copy (insert) will not create a duplicate record. Regards Honyo

Hi I have now tried 25 different ways to do this but have finally given up. If anyone can help, then I would greatly appreciate it. I have a Production SQL server (SQLD) in Denver I have a Production SQL server (SQLV) in Vancouver I have a new SQL server (SQLNew)also in Vancouver (different...

Hi Please can someone help an absolute newbie. I currently have the following: SQL Server 7 (BCSQL1) Database = AVS Table = Agent_Info Columns = Agent_User_ID Agent_Name Login_Date Logout_Time Duration Password SQL Server 2000 (BCCRS1)...

Hi I am using 8.5, SQL 7 and need some help with groups. I have created a group called BTN. There are various records under each BTN group. The one record is a value of 0, 1 or 2 (string value). BTN address PFI e.g. BTN1 abcdef 1 rtyuer 1 iooiuh...

Thanks to all, I got it to work. I had the test 1 formula in the details section but was still getting 0.00 for all fields. I changed the first formula to read: local numbervar pass; if ToNumber({Transaction_Info.Pass_Fail}) = 1 then pass := pass + 1 I then used your second formula...

HI Thanks for the info. I tried it but it just gives me 0 values. Regards Honyo

Hi Please can someone help me with an issue that has me running around in circles. The report is pulling data from SQL I have a group called {Trans_Feature_Info.BTN} Under BTN it lists a status of calls Y,N or I pass=Y ; incomplete=I ; fail=F Some BTN's are listed more than once If BTN is...

Hi I currently have a string field with a length of 9 characters. If the length is less than 9, then I need to add zeros to the front of data. E.g. 45678 will become 000045678 I need the formula to get the length of the string and with anything less than 9, it adds the 0. Sounds easy, I know...

Thanks Ido. My problem is that the records are sitting in 2 seperate SQL server machines. I got the union to work but only if the tables are on the same server. I need to something to bridge the 2 servers and then join the tables so that I can pull the records vai Crystal. Regards Honyo

Hi I currently have 2 sql servers running (Denver and Vancouver). Both have identical databases, tables and columns. The data in these tables is however different - Denver all starts with 1 and Vancouver all with 2. I have create 2 seperate reports and both connect to their respective...