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 bkrike 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: *

  • Users: Honyo
  • Content: Threads
  • Order by date
  1. Honyo

    Hi Can anyone help me here. I h

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

    SQL & Exchange 5.5

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

    Insert / Select and Variable help

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

    Select and Insert with INNER JOIN?

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

    Select and Input between servers

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

    generating group value from records

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

    Totals and Percentages

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

    Crystal String Formula

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

    Crystal Reports - data joining

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

    Formatting e-mail once submit clicked in form?

    I need to have an e-mail sent in a specific format once a form has been completed and the submit button clicked. I have used the Front Page 2002 "form" and it generates the e-mail. The formatting is terrible. How do I change the e-mail format or even the output result once the submit...

Part and Inventory Search

Back
Top