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 John Tel 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: thorntong
  • Content: Threads
  • Order by date
  1. thorntong

    Trying to access data via DSN connection

    Good Morning All, I am trying to see if I can make a direct SQL call using an OPENDATASOURCE call to a DSN that has been setup on my SQL 2005 server. And I am having trouble with the syntax using this type of call. I am trying to access the OD_RECEIPTS table within a ODBC System Name of...
  2. thorntong

    Create Incremented Column using UNION statement

    Hi Everyone, I am trying to figure out how I can increment a counting column while using a UNION statement. I have created a separate table to store the current value. Here is my query: SELECT PatID, VID, RunDate, null AS 'Status' FROM dbo.VT_Blueprint_BP UNION SELECT PatID...
  3. thorntong

    Prevent Duplicate Records With Label Report

    Good Morning, I'm using Crystal XI and I'm having problems with a mailing label report that I cannot seem to prevent duplicate patient addresses from being displayed. The reason that I'm getting duplicate data is because a patient can have multiple doctor visits within a 2 year span. I thought...
  4. thorntong

    OLE object prints as black box

    Hi Everyone, I'm using Crystal XI and I'm having a problem with a report that has an embedded OLE object (Excel Spreadsheet) in it. The report runs perfectly fine and everything, except when you try and print it. The Excel Spreadsheet is being displayed as one huge black box. Has anyone seen...
  5. thorntong

    Creating Multi Page Report Using OLE Objects

    Hi Everyone, I am in need of some guidance in regards to creating a multi page report using OLE objects. I am using CR XI and I am creating a billing sheet for one of our departments. I created the actual billing grid sheet using MS Excel. The report runs against our patient DB and pulls in...
  6. thorntong

    Learning ASP.NET

    Hi Everyone, I am looking to learn ASP.NET and I was wondering if anyone knew of any online training courses that were very good and you really got a lot out of the class. I would greatly appreciate any assistance/guidance that you may have. Kind Regards, Glenn
  7. thorntong

    Convert Date/Time to HL7 Date/Time

    Hi, I'm working with an SQL 2000 DB to extract an appoitment date/time and trying to format it so that I can insert it into an HL7 message. Here is the command that I am using to extract the date and time fields...
  8. thorntong

    Incorrect syntax near ')' when using DTS

    Hi, I'm in the process of trying to convert a MySQL DB (ver 3.0 on Linux) over to a SQL 2000 DB (Windows) and I'm using the DTS (Data Transformation Service) built into SQL 2000. When I run the utility, it is successful in copying over 15 of 17 tables. But what I'm getting is a Incorrect...

Part and Inventory Search

Back
Top