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

    CSS and include files.

    Hi Folks, So I have inherited the upkeep of a web site and I am instituting css in several areas. All the pages are asp but they are essentially just html with a couple of include files. One of the include files handles a upper right hand Nav. So this nav does not seem built by this include...
  2. NewbieDBA

    Slave reformated to by Master

    Hi Folks, I have a Maxor 4 (Gig) hard drive which is currently Slaved on my Home PC (Call it computer A). I reformatted the slave Maxor in computer A to be blank but formatted (Forgive me I am not a hardware guy). I am trying to stick it into several old 300mhz machines salvaged from the dregs...
  3. NewbieDBA

    Arithmetic overflow error

    Hi Folks, The idea behind the query is to get every address_line_1 that has 'Street' and use notepad to make them all 'St' instead. Inane, but someone must have it this way. I can't get the following to run: select 'update address set address_1 = ~' +address_1+ '~ where address_id = ~' +...
  4. NewbieDBA

    Exclusion query logic problem

    Hi Everyone My sense and logic has left me. I need some help with my query. I have one central table, meeting_registrant. I am attempting to find all of the people who have attended meeting 1072 who have attended any other offering, except for meetings in the meeting_class which 1072 belongs...
  5. NewbieDBA

    Exclusion Query Logic Issues

    Hi Everyone My sense and logic have left me. I need some help with my query. I have one central table, meeting_registrant. I am attempting to find all of the people who have attended meeting 1072 who have attended any other offering, except for meetings in the meeting_class which 1072 belongs...
  6. NewbieDBA

    Creating Several PDFs from one File easily

    Hi all, I am new to Acrobat. Using the version 5.0 does anyone know of a way to save individual thumbnails as their own PDFs quickly? The database I manage creates output invoices in large .log_# batch files. For example; FAR_610.Log_978 will have 200 outstanding invoices. This is great if...
  7. NewbieDBA

    Simple SQL Multiplication Question

    Hi Folks I am trying to multiply a virtual column by a real column. Can I do this? Let me show you what I mean: SELECT REGIS_RATE, Count (REGIS_RATE) AS REG_NO, RATE_AMT, (REG_NO*RATE_AMT) AS TOTAL FROM MEETING_REGISTRANT WHERE (MEETING = '1072') AND (MEETING_REGISTRANT.ORDER_STATUS <> 'C')...
  8. NewbieDBA

    SUB Query is no running

    Hi I wrote a little query to compare to lists in our database. One list is tracking organization belonging to a meta organization. The other list is tracking some individual customers. Because they are both considered customers [living in the customer table] they have separate customer numbers...
  9. NewbieDBA

    Query Counting returns in an inner join.

    Hi I have an ongoing question. I am trying to get this query to work and I am having the devil of a time working it out. So: SELECT PHONE.PHONE, PHONE.PHONE_TYPE, PHONE.CUSTOMER, MEETING_REGISTRANT.SHIP_CUSTOMER, MEETING_REGISTRANT.MEETING FROM PHONE INNER JOIN...
  10. NewbieDBA

    Counting Number of repeats in a Colum of Data

    Hi I am new at this and I am trying to create a query where I find customers who have registered for three or more of our meetings in a five year period and I am getting bogged down in complexity. My core issue (may be simple) how can I create a count out of the Meeting column in the...

Part and Inventory Search

Back
Top