Search results for query: *

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

jeremybarker Good advice. I am setting the cable position correctly but I didn't know there was a small jumper piece that tells the hard drive that it is the master. Something to try tonight when aI get home. Thanks

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

fluteplr I've never really seen this structure before, and it works great. Thanks Let me show you what my structure does. Select 'update address set address_1 = ~' +address_1+ '~ where customer = ~' + customer + '~' FROM address WHERE address_1 LIKE '%Street%' Results...

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 = ~' +...

Solution!!!!!!!!!!!!! SELECT OneTime.SHIP_CUSTOMER FROM (Select For01.SHIP_CUSTOMER FROM (SELECT SHIP_CUSTOMER, ORDER_STATUS, MEETING FROM MEETING_REGISTRANT WHERE (MEETING = '1072') AND (ORDER_STATUS <> 'C'))For01 LEFT OUTER JOIN (SELECT MR.SHIP_CUSTOMER FROM...

Bye the way thank you for your help rac2.

Your code is tighter than mine but I am still getting individuals who are registered for 'FOR' class meetings. I had a new thought. What if I break out each of the 20 or so FOR class meeting into their own virtual tables. I picture a snowball rolling downhill in slow-motion reverse, shedding...

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

Thank you both for replying: Terry, I am running this in MS Query Analyzer that came with SQL Server 7 service pack 5. Mike, I think I am misunderstanding you. The query is set up essentially as you have suggested. The q1072 = FORUM01 which is inner join[ed] to qNotFOR = ALLELSE. The...

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

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

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')...

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

Terry. You're a master. Thanks

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

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