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 TouchToneTommy 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: cybermud
  • Content: Threads
  • Order by date
  1. cybermud

    Sum Of Sums On Two Unrelated Tables

    Gang: I have two unrelated tables that contain dates and amounts. I would like to sum these amount and group by date but I am having problems doing it with a single query. I can do it using a temp table, but I would rather do it using a single query. Perhaps someone here can help. sPayments...
  2. cybermud

    Query Returns < and > character

    Gang: I have a databse query which returns a string. The string may contain the > and < character. When this is outputted, characters beyond the < do not display. Any tips on getting those characters on the page? Thanks, Cybermud
  3. cybermud

    Remote SQL Servers

    I have several remote SQL Servers which I get data from on a daily basis via a VPN link over the internet. The method that I use is a SQL Server Agent job that executes a stored procedure which connects to each remote server (sp_addlinkedserver), sets up a logon (sp_addlinkedsrvlogin), and...
  4. cybermud

    Incomplete Queries

    I have a paradox 9 database that is updated every half hour by an external system....I am trying to query that in Excel using MSQuery manually, on a daily basis, to make a chart. My problem is that the queries are incomplete. For example, I have data up to today, that I can see if I view the...

Part and Inventory Search

Back
Top