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 Chriss Miller 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: *

  1. txwylde

    Counting email name length

    I have an email field that I would like to count and put the results in a where statement. Longer emails would be suspicious. How do I go about doing that? Thanks! Bill
  2. txwylde

    Check for upper Case Characters

    I have an email variable that I would like to check to see if it contains an uppercase character. In MySQL i was able to use this in my where statement: where ascii(substring(billto_name,2,1)) >= 65 and ascii(substring(billto_name,2,1)) <= 90 How do I use the Case function to check to see if...
  3. txwylde

    IP addresses with port numbers, need to extract class c addresses

    Apparently there are no blanks in the numbers since I cut and pasted the IPs and put these IPs into TextEdit. I have used the substring to try remove the extra IP addresses.
  4. txwylde

    IP addresses with port numbers, need to extract class c addresses

    I have a huge list of 8500 ip addresses. In some instances, they have port numbers. I have tried importing the list in a temp table and then doing a substring but it still gives me some lines with extra spaces. For example, I did a select substring(ip, 1, 11) from test being the class c...
  5. txwylde

    How to import into a table with a file

    I got it. I did not realize I could move the local file over. I thought I had to do it on the same sever that the database was on. Thanks for your help. take care Bill
  6. txwylde

    How to import into a table with a file

    Our Database server has moved off of the local machine and is by itself. When I try to run: load data local infile '/Users/test/Documents/CC.txt' into table bi_kinkead.new_macbook; test.reseller_cc I get an error because the file is not located locally. It is locaed on a server called Pluto...
  7. txwylde

    Updating a Table

    Ahh.. once I took out the alias it was fine. I was just not thinking. :(
  8. txwylde

    Updating a Table

    I am trying to update a temp table by querying the values of another table. Here is my SQL: insert into bi_kinkead.vietnam_fraud v select * from bi_warehouse.archive_order_summary a where a.sales_order_num in ("7055089764", "7055106301", "7055218969", "7055220663", "7055233089", "7055283807"...
  9. txwylde

    Creeating Korn Shell to run 2 SQL scripts

    Thats one way. I wanted to create a chron job and have this script run every week. Is there a different way to do it? Thanks! Bill
  10. txwylde

    Creeating Korn Shell to run 2 SQL scripts

    I am trying to create a script that will run 2 sql scripts in Korn shell but a little lost. Does anyone have any examples that I can use as a guide? The 2 SQL scripts are called loopers_fiscal.sql and looper_query_v2.sql. Thanks! Bill
  11. txwylde

    How to calculation number of weeks in a month?

    I need to create a variable that I can use to calculate the number of weeks in 1 month. Some months will have 5 weeks and some will have 4. Is there an easy formula to do this? thanks! Bill
  12. txwylde

    Counting records from three tables

    I have three tables I am trying to do a count on to give me a total amount. The problem is that somes of the sales order numbers are unique to the other tables but I want to count the unique records as well as the records that are not in the other tables. Is there an easy way to do this...
  13. txwylde

    Grouping data by a time stamp

    Here is the order_time field: 02:00:59 HH:MM:SS I tried DATE_FORMAT(order_time,CONCAT('%Y-%H','-',(FLOOR(MINUTE(order_time)/15)+1)*15)) as my15min but it does not group it in 15 min increaments. Is there something I am doing wrong? Thanks! Bill
  14. txwylde

    Distinct Question

    I do not want to limit to just 1 row. If I runt he query as is I get about 13000 records. I then pull a Material Number up and have 7 records when I should just have one. take care Bill
  15. txwylde

    Distinct Question

    I am trying to build a table that lists products by their material number and their desecription. I am pulling this information from another table. My problem is I am getting mulitple Material Numbers with the same description. Here is my query: create table pricing select distinct...
  16. txwylde

    Adhoc Reporting tool for mySQL?

    Is there an Open Source reporting tool for mySQL? I would need it to run on Mac OS X. I have a few I am looking at but they are very hard to configure and use. It would be nice to have something like Business Objects or Crystal Reports. (There is a Business Objects version for the OS X but my...
  17. txwylde

    Grouping data by a time stamp

    I have a query where I am doing some counts as data is coming in. There is a order_time field where I am selecting hour(order_time) as hr and then grouping by the data and HR. If I wanted to break the order_time in 15 minute increaments, how would I got about doing that? Thanks! Bill
  18. txwylde

    How to do a running talley

    I have an excel spreadsheet. In my A column, I want to run it to count up if the C column is not null. I have tried the SUMIF but can not seem to get it to work. How can I go about preforming this function? Thanks!
  19. txwylde

    Business Objects and mySQL?

    I noticed that mySQL and BO has formed a partnership but have not heard anything with regards to whent his product is coming out. Anyone have any tricks getting mySQL to hook up to BO in the interim? thanks! Bill
  20. txwylde

    Query question- Bringing back orders with more than 1 product.

    I am trying to create a query that will pull back orders where there is more than one item in the list. I have tried to do a count on product_group and then tried doing a count on material_num but it still brings back the unique records. Here is my SQL. Thanks! Bill select order_date...

Part and Inventory Search

Back
Top