r937
SQL Consultant
Devshed Supreme Being (6500+ posts)
- Join Date
- February 25th, 2003
- Last Activity
- Yesterday 09:12 PM
Basic Information
- Location:
- Toronto Canada
- Occupation:
- freelance SQL consulting
Signature
Statistics
Posts
- Total Posts
- 27,026
- Posts Per Day
- 6.64
General Information
- Last Activity
- Yesterday 09:12 PM
- Join Date
- February 25th, 2003
-
Older Activity
-
April 16th, 2014, 06:11 AM6 replies | 159 view(s)
-
you set the $sql variable with a string for your INSERT statement you fail to execute it then you set the same $sql variable with a string for...April 16th, 2014, 05:45 AM6 replies | 159 view(s)
-
you don't want a trigger, and you don't want a procedure in fact, you don't want to store the calculation at all just calculate balance due...April 12th, 2014, 04:51 AM1 replies | 235 view(s)
-
don't touch the join conditions other than the CamID the date range condition in is the WHERE clauseApril 8th, 2014, 11:15 AM8 replies | 187 view(s)
-
caution: untested i gave you six years of range SELECT yrs.yr , mths.mth , Contracts.ID , Contracts.Client ,...April 8th, 2014, 11:06 AM8 replies | 187 view(s)
-
no, no, no, you don't have to do that, man can you give us the absolute largest range of dates, please also, you seriously already have revenue...April 8th, 2014, 10:50 AM8 replies | 187 view(s)
-
so, remove the LIMIT :)April 4th, 2014, 02:31 PM2 replies | 132 view(s)
-
use the students as your left table, and write a plain old vanilla LEFT OUTER JOIN to the tracker table formatting the data in a grid is not...April 4th, 2014, 12:34 PM1 replies | 105 view(s)
-
okay, that means you need to grab the maximum of the combined columns you still need to google "groupwise max" :)April 1st, 2014, 07:44 PM3 replies | 118 view(s)
-
actually, 1,2,4,5, because 1 and 2 are tied google "groupwise max"April 1st, 2014, 05:22 PM3 replies | 118 view(s)
-
my guess: you're joining on the wrong columns one's a code (character?), the other's an id (numeric?)March 29th, 2014, 09:05 PM4 replies | 197 view(s)
-
that's gonna be quite problematic for a trigger here's a suggestion -- develop a query which calculates the amount "on the fly" and then save the...March 26th, 2014, 03:17 PM2 replies | 154 view(s)
-
preferably these would be ON conditions in the joins, not WHERE conditions oh yes, indexes improve performanceMarch 25th, 2014, 11:57 AM19 replies | 600 view(s)
-
actually, this should say: no table or column names should be surrounded by backticks backticks are useless, except where they are used to delimit...March 25th, 2014, 05:31 AM3 replies | 243 view(s)
-
re: the duplicates you were getting -- in your query, your WHERE condition restricted only player1's results...where...March 24th, 2014, 12:57 PM19 replies | 600 view(s)
-
UPDATE cpe_device_audit_copy SET changetime = '2014-01-23 14:47:00' WHERE lastupdate = 'Martin Camble: Thur Jan 23 14:47:00 GMT 2014'March 24th, 2014, 08:52 AM12 replies | 449 view(s)
-
do this first --ALTER TABLE pga_championship_2013 ADD INDEX player1_key ( player1 ); ALTER TABLE pga_championship_2013 ADD INDEX player2_key (...March 24th, 2014, 08:49 AM19 replies | 600 view(s)
-
okay, i can see what you posted, i'll get back to youMarch 23rd, 2014, 09:26 PM19 replies | 600 view(s)
-
perhaps in addition to the sql fiddle, or instead of, you could just dump the tables and then copy/paste a handful of the INSERT statements here, we...March 21st, 2014, 04:24 PM19 replies | 600 view(s)
-
your query should actually work not sure where you're getting "repeating records" from next step in tracking down this problem is for you to...March 20th, 2014, 07:25 PM19 replies | 600 view(s)
-
i tried to compare your attempted query with your description of the problem in post #1 and i am lost could you do a SHOW CREATE TABLE for each...March 20th, 2014, 09:03 AM19 replies | 600 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Query help
August 24th, 201303:09 AMUser / Points
You gave 0 toComment
i would have expected some kind of suggestion for a new data model and not just the usual diatribe/rant about what's wrong with the current one -
Thread / Date
Display 2 queries in the same table?
November 6th, 201207:56 PMUser / Points
You gave 937 toComment
thanks for taking the time to give examples! very helpful for new developers -
Thread / Date
Update first X rows?
August 21st, 201209:29 PMUser / Points
You gave 937 toComment
what dan said -
Thread / Date
Putting condition in ON clause or WHERE clause
August 17th, 201209:18 AMUser / Points
You gave 937 toComment
very nicely explained, great tutorial -
Thread / Date
Trying to get a count of certain records - PHP/MYSQL
January 13th, 201202:04 PMUser / Points
You gave 937 toComment
nice explanation, guelphdad
-
Thread / Date
Problem with slow query
October 18th, 201103:47 PMUser / Points
You gave 2937 toComment
stefan is my tuning hero
-
Thread / Date
Complicated table join question.
September 15th, 201108:29 AMUser / Points
You gave 937 toComment
sweet
-
Thread / Date
Help with a query
June 5th, 201108:21 AMUser / Points
You gave 2937 toComment
lol
-
Thread / Date
Urgent help Find Replace Query
June 21st, 201009:36 AMUser / Points
You gave 937 toComment
nicely explained
-
Thread / Date
Trying to get one column only grouped by a "id"
June 4th, 201011:33 PMUser / Points
You gave 937 toComment
sweeeeet!!!
Latest Reputation Received 417193 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Selecting fields from two tables
March 5th, 201405:22 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:57 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query help - Head-To-Head Win/Loss Record
March 1st, 201408:52 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Left join weekdays and time interval
February 26th, 201402:51 PMUser / Points
You recieved 10 fromComment
No Comment Made -
Thread / Date
Query for multiple date ranges at the same time
February 13th, 201407:30 AMUser / Points
You recieved 3 fromComment
No Comment Made -
Thread / Date
Using Multiple Selects in One Query
January 15th, 201411:16 AMUser / Points
You recieved 5 fromComment
Wow! Now that is a query! -
Thread / Date
Triggers
January 9th, 201403:49 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query runs to long in spite of index
December 9th, 201304:00 PMUser / Points
You recieved 64 fromComment
Thank you for the help -
Thread / Date
Replace value with null
December 3rd, 201311:12 AMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Query to determine duplicates
November 20th, 201303:07 PMUser / Points
You recieved 0 fromComment
No Comment Made
