Re: Tough query to crack

he stored procedure thing and only a little better at SQL statements as a whole:) Steven J Orton Software Engineer Northrop Grumman Mission Systems Middletown, RI 02842 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED]] Sent: Wed 6/28/2006 4:57 PM To: Orton, Steve; mysql

RE: Tough query to crack

on Systems Middletown, RI 02842 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wed 6/28/2006 4:57 PM To: Orton, Steve; mysql@lists.mysql.com Subject: Re: Tough query to crack />I don't think that will work because Context_ID is not found in 'target

Re: Tough query to crack

02842 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED]] Sent: Wed 6/28/2006 4:01 PM To: Orton, Steve Cc: mysql@lists.mysql.com Subject: Re: Tough query to crack Steve, > INSERT INTO master_context_list (Context_ID, Target_ID) >SELECT Context_ID = @ContextID,

RE: Tough query to crack

the IDs are put into the APPLICABLE_TARGET_IDS temporary table. steve--- Steven J Orton Software Engineer Northrop Grumman Mission Systems Middletown, RI 02842 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wed 6/28/2006 4:01 PM To: Orton, Steve Cc: mysql@lists.mysql.com Subject:

Re: Tough query to crack

Steve, > INSERT INTO master_context_list (Context_ID, Target_ID) >SELECT Context_ID = @ContextID, targets_list.Target_ID FROM targets_list > WHERE Target_ID IN ( SELECT Target_ID FROM #APPLICABLE_TARGET_IDS ) [EMAIL PROTECTED] tells the server to return 1 when the column value of co

Re: Tough Query Problem

- Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Aaron Clausen" <[EMAIL PROTECTED]> Cc: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, June 16, 2004 10:20 Subject: Re: Tough Query Problem > In the last episo

Re: Tough Query Problem

In the last episode (Jun 16), Aaron Clausen said: > I am trying to write a script that can take logs from our mail > server, boil down the rejections to determine the sources of > distributed SMTP dictionary attacks against our mail server. > > Basically I have a table "send_failures like this tha

Re: Tough Query for this New DBA

Brian, Identical area codes will not get you nearest neighbours in cases of metro areas with multple area codes, or in cases of nearby companies on different sides of area code boundaries. For nearness, you need need to plug in geographical data, I think. On your approach, though, are you looking

Re: Tough Query for this New DBA

Hi Brian, Not answering your question, but are your table names really "table1", "table2" etc? If so, you will be running into more problems :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscen

Re: tough query

At 6:10 PM -0700 8/30/01, Daren Cotter wrote: >i have a query that needs to do the following: > >in my members table, i store the member id, and the referer id of the member >that referred them (the referer_id links to the member_id). > >for example, a member signs up and gets the id of 0200289, a

Re: tough query

> i have 3 tables: offers, rewards, and sources. sources has just a source > name and source id. both the offers and rewards tables have a "source_id" > field which relates to the sources table. i need to write a query that > selects the source name and the count in each table with that source id.