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!
-
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!
Recent content by clone45
-
DTD question - deling with child elements will the names?
Oh shoot, I really mangled the subject. Sorry. -
DTD question - deling with child elements will the names?
Hello! This is a totally newbie DTD question. Let's say that I have the following XML: <?xml version="1.0" encoding="utf-16"?> <root> <person> <name>John Doe</name> <pets> <pet> <name>Fluffy</name> <type>cat</type>... -
SQL query with results formatted for table output?
r937, You had it correct! I didn't copy your query properly. Great job! -
SQL query with results formatted for table output?
FANTASTIC!! Your solution worked perfectly, except that some of the columns were duplicated in my results. It was pretty easy to solve though. Here's the final query. Thanks for teaching me about CROSS JOIN! SELECT domains.domain,weeks.week, visitors FROM ( SELECT DISTINCT domain... -
SQL query with results formatted for table output?
r937, thank you so much for the detailed response! I don't actually have a domains table or a weeks table. All I have is a domain_report table which has the fields: week, domain, and visitors. So I'm most interested in your second solution. Just to reiterate your solution with some minor... -
SQL query with results formatted for table output?
Hello, I'm building a report for a client who wants to know how many visitors are reaching his site based on the domain name entered by the visitors. For instance, some visitors may type in "foo.domain.com","domain.com", or "mobile.domain.com". The report needs to be broken down by week and... -
left join with unique rows from joined table?
Hello! Thank you for the responses. I have some follow up question. First, though, I wanted to clarify that fluffy is a cat, not a dog. :-) Quite honestly, I can't make heads or tails of the ANSI compliant version. What's bi_stg_8.ti? Well, anyhow, I've been focused on this proposed... -
left join with unique rows from joined table?
Hello! Say I have the following tables: Pets ===== id - integer (pk) name - varchar type - varchar notes ===== id - integer (pk) pet_id - integer (fk) note_text - text date - date/time I'd like to query for pets of type "dog", and I'd like the query to also return the most recent note... -
Help with count( ) with a query containing math
Fantastic! I never knew that existed! -
Help with count( ) with a query containing math
Hello! I'm having some trouble getting my syntax right. Here's my original query: SELECT name, longitude, latitude, address, id, created, image,(((acos(sin(($latitude*pi()/180)) * sin((latitude*pi()/180)) + cos(($latitude*pi()/180)) * cos((latitude*pi()/180)) * cos((($longitude -... -
Rewritting a slow query that uses "in" ?
Thanks mrdenny, I was using outer joins because I wanted visitor rows to show up regardless if they were associated with a campaign. I'll see what happens if I count(ctokens.ctoken) instead. I must admit, although I can handle simple queries, these big ones are a mystery. Are there any good... -
Rewritting a slow query that uses "in" ?
Hello! I have a follow up question. The query above seemed to work fine and I'm trying to extend on it. I'm trying to list out the number of visitors coming in to the site with a specific uuid. The list should also contain the campaign name if it exists, or NULL otherwise. In my previous... -
Rewritting a slow query that uses "in" ?
I'll have to follow up tomorrow to be certain, but I think that's it! I'll have to read up on my inner joins to understand exactly what's going on. Thanks! - Bret -
Rewritting a slow query that uses "in" ?
Hello! I keep running into situations where I use the "in" operator which results in really _slow_ queries. I need to find a graceful way to work around it. Here's my example.. We have a table called "campaigns" (for marketing campaigns) and another table called "tokens" (representing uuids... -
Showing a count of visitors who are in the database more than 3 times?
Excellent! It works great! Thanks!
