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 Mike Lewis 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: CruzN
  • Order by date
  1. CruzN

    Using a Case Statement to select which database to use within a Routine

    Hello, I am trying to eliminate the need for creating multiple Routines which are doing the same thing on different databases. I would like to use the "USE DB1;" syntax at the beginning of a routine to determine which database to look at. Each database has the same structure (Tables/Views)...
    • CruzN
    • Thread
    • Replies: 2
    • Forum: MySQL
  2. CruzN

    Combining SQL Server with MYSQL Views in Crystal 2008

    Thanks for the insight. That makes sense, keep it on 1 server and have all of the linking done on the server side. It sounds like it would work. I've been doing some digging, and have read that there are ways to link to a server in MS SQL, but I dont have any idea on how to do it. Hopefully I...
  3. CruzN

    Combining SQL Server with MYSQL Views in Crystal 2008

    I am connecting to 2 different datasources (SQL Server and MYSQL) in CR 2008. I am joing a SQL Server Stored Procedure to a MYSQL View on Date and User ID. (I am trying to retrieve the records for over 300 CSR's by day for a drill down report). My problem is that even when using the stored...

Part and Inventory Search

Back
Top