Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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!

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

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

I am trying to create a query where I am bringing back order_date, ip_address and email_address. I only want those records where the count of the ip_address is greater than 2. Here is my code. select count(ip_address) order_date, email, ip_address from risk.fraud_orders where...

I have a query that I want to limit the data if the Setup Amount is equal to the Dispotion Code and the Reason Code is 0007. Is there a way to limit the data coming back in the Query Panel Window? Take care Bill

I have a variable called Paid Month which gives the date as 200312. How can I go about creating a variable which gives me the number of weeks in that particular month? Thanks Bill

I was sent the source file that gets fed into Crystal reports to produce this document in adobe. Is there a way in Crystal to get it to save in WORD format instead of Adobe? take care Bill

What is the fuction to keep tables that you have inserted from overlapping in case the prior table has new data when refreshed? Thanks! Bill

I have a report that I need to add the paid claims and the denied claims to give me a total claims. I have two prompts which a user enters one date and the other to compare a month in 2003 to 2004. Here is what I have for the variable for TOTAL CLAIMS 2003 =((<Number of Denied Claims>) +...